How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / kamalakar
by using pre sql in source qualifier we can generate
sequence in the target
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the data movement modes in informatica?
What is enterprise data warehousing?
How do you promote a non-reusable transformation to reusable transformation?
What are the components of Informatica? And what is the purpose of each?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is a pre-defined event and user-defined event?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Target increases every day even though no new record was inserted
what is the Default Source Option For Update Strategy Transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are multi-group transformations?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
if we have a delimiters at unwanted places in a flat file how can we over come those.