Interested to Buy Any Domain ? << Click Here >> for more details...
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c
i want output as 1 a,b,c and 2 a,b,c ...
how can achieve this
- 5 Answers
- 10370 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / swetha
Thru Normalizer t/r we can acheieve this.
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Different sorts of metadata that stores in the storage facility?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is a node in Informatica?
What are the differences between oltp and olap?
In warehouses how many schemas are there?
how to load dimension table and fact table. plz tell me the steps.
What is the need of an ETL tool?
What does cheating measurement mean?
What is the Process to creating lookup transformation in informatica
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to generate sequence numbers using expression transformation?
