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
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the benefit of partitioning a session?
What is a transaction control transformation?
What is mapplet in informatica?
What is the need of etl tools?
Where are the source flat files kept before running the session?
Mention a few design and development best practices for informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the different lookup cache(s)?
How to update or delete the rows in a target, which do not have key fields?
whats the logic to load the lower level of granularity of data to fact table.
what is SDLC way of code development?
What is a surrogate key?
How to use pmcmd utility command?