1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
IBM,
3 9413source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
5 9146source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
2 5486Post New Informatica Questions
Design a mapping to load a target table with the following values from the above source?
my source is junk data how will u remove that junk data by using unix please any one replay me
What does cheating measurement mean?
How many input parameters can exist in an unconnected lookup?
What are the types of caches in lookup?
What is a surrogate key?
What is data transformation manager process?
What is informatica etl tool?
How you know when to use a static cache and dynamic cache in lookup transformation?
What do you mean by channel change?
How to update or delete the rows in a target, which do not have key fields?
How do you load alternate records into different tables through mapping flow?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How do you load only null records into target?
Define filter transformation?