Can we use Union Transformation for Heterogeneous sources?
i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
- 3 Answers
- 9085 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ananta mishra
yes
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Which means the first record should come as last record and last record should come as first record and load into the target file?
What do you mean by enterprise data warehousing?
What are data-driven sessions?
What are the tasks that can be performed using sq?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
if we have a delimiters at unwanted places in a flat file how can we over come those.
Briefly describe lookup transformation?
How union transformation is used?
How to create the source and target database connections in server manager?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
lookup transformation with screenshots
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What if the source is a flat-file?
