Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4964 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 |
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
without matching columns in two tables. how can you join
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
How do you load only null records into target? Explain through mapping flow.
What is mapping debugger?
What is the difference b/w natural key and surrogate key
how to calculate the optimum cache size in aggregator transformation?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
what is difference between dimention table and fact table?
To provide support for Mainframes source data,which files r used as a COBOL files
What could be the possible resons of locks by user?
Teradata 
