I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
1 3201my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
ACS,
3 6562Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
1 3882we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
TCS,
3 7036i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
1 4612in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
3 11944in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 8298i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
6 10007in 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?
2 5966Post New Informatica Questions
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain the difference between a data warehouse and a data mart?
What is confirmed fact in dataware housing?
How identifying bottlenecks in various components of informatica and resolving them?
What does “tail –f” command do and what is its use as an Informatica admin.
What is workflow? What are the components of workflow manager?
Explain the types of lookup transformation?
Is there any target staging area in informatica not staging area
What are the different options available for update strategy?
How are indexes created after completing the load process?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is dimensional table? Explain the different dimensions.
What do you mean by filter transformation?
What is the need of an ETL tool?
What is a pre-defined event and user-defined event?
