Interested to Buy Any Domain ? << Click Here >> for more details...
After dragging the ports of 3 sources
sqlserver,oracle,informix to single source qualiofier can
we map these ports directly to target and how?
- 2 Answers
- 7133 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rao
How can you join 3 heterogeneous sources to a single source
qualifier?.
For this you need to use 2 joiner transformations and the
resulted cloumns can be connected to the target.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / veeru
No,
By joining the three sources, we can load in to the target
| Is This Answer Correct ? | 0 Yes | 5 No |
what are the limitation of sorter transformation?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
How many joins in Informatica
what is data driven?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
Why we select the table which has minimum number of records as Master table in joiner?
What is dimensional table? Explain the different dimensions.
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
Teradata 
