if i am having 10 records in source, i want 20 records in
target...how will you do it
Answer Posted / priyank
Take 2 instances of the same source and join them using
Union transformation which acts as the UNION ALL command of
SQL i.e. it allows duplicates too.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is rank index in rank transformation?
Describe data concatenation?
What is a sequence generator transformation?
Write the unconnected lookup syntax and how to return more than one column.
What are some examples of informatica etl programs?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How an expression transformation differs from aggregator transformation?
What is a surrogate key?
What is the Process to creating lookup transformation in informatica
Can we create multiple integration service on single repository?
What are the types of presistent cache in look up tr.
What is a repository? And how to add it in an informatica client?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?