What are the reusable transformations?
No Answer is Posted For this Question
Be the First to Post Answer
Informatica settings are available in which file?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
How can we create index after completion of load process?
1 lac of flat fles in source how to load target at a time?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
Differentiate between reusable transformation and mapplet.
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
Can you generate sequence numbers without using the sequence generator transformation?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.