i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
- 1 Answers
- 3948 Views
- HCL, I also Faced
- E-Mail Answers
Answer / harish konda
1. Declare workflow and mapping variables and assign them in Pre and Post session.
2. Use Transaction control transformation to create the target files dynamically.
Like everytime you run the session you can create the target file with the value of mapping variable as a run number.
| Is This Answer Correct ? | 2 Yes | 1 No |
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is update strategy transformation ?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the difference between STOP and ABORT options in Workflow Monitor?
what is mapping override?
What are the new features of informatica 9.x at the developer level?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
how to load rows into fact table in data warehouse
Explain the flow of data in Iinformatica?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
Explain grouped cross tab?
Teradata 
