i have two source data there is no pk,fk how to join the
two sources
Answer Posted / chandrababu.sarupuru
To join these sources we will use SQL Override function in
Source qlalifier transformation....
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is rank transformation?
What if the source is a flat-file?
In development project what is the process to follow for an etl developer from day1
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Is it possible to define a single node as a Gateway node as well as worker node?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
As union transformation gives UNION ALL output, how you will get the UNION output?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
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?
How to convert multiple rows to single row (multiple columns) in informatica
How many transformations can be used in mapplets.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the reusable transformations?