Hopefully thisĪpproach will work better for me and break down the complexity! Have to load as the foreign keys in my target. Then, while joining these two flat files, I have toįind the corresponding primary keys on the 4 tables, which I So, I decided to write all the teradataĬolumns to a flat file, and all the oracle columns to anotherįlat file. Teradata tables! It is becoming a nasty mapping if I try to doĪll this at one go. Have nearly 20 columns that will come from joining 18 different ![]() ![]() Other than this, this table will also have 8-10 columns that I Have the primary keys of 4 different DW tables as foreign keys. So, whats NEW about the NEW Yahoo! Messenger? Find out. Can anyoneįind out what India is talking about on Yahoo! Answers India. The joiner does not seem to do the trick for me. I have a complex set of conditions that I have to join on, and If that is the case, can I pull in a DB table just to be That you cannot override the SQL if your sources are 2 flatįiles. That I need to join, but I was reading somewhere on this forum can we people hve little idea abt ur conditions as well.Ĭan I override the SQL in the source qualifier if my sources areĪ flat file and a database table? In fact, I have two flat files If ur joiner transformation is not helping u in acheiving the required functionality then u can try loading ur data first in a temp table then u can join both the tables in sql override and in post script u can drop ur temp table as well.īut i really doubt how ur joiner transformation is not helping u. To join a flat file with DB, or to join two flat files u need the joiner transformation. ![]() NO, friend if ur source is a flat file then u cant go for SQL override.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |