whatis the default data driven operation in informatica
Answers were Sorted based on User's Feedback
Answer / umarao
This is defauly option for update strategy transformation.
The intigrationservice follows instructions coded in update
stategy within session mapping detarmine how to flag
records for insert,delete,update,reject.if you do not
datadriven option setting,the integration service ignores
update strategy transformations in the mapping.
| Is This Answer Correct ? | 0 Yes | 0 No |
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Why use the lookup transformation ?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
What differs when we choose the sorted input for aggregator transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How will the document be delivered to me?
how much memory (size) occupied by a session at runtime
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure