Interested to Buy Any Domain ? << Click Here >> for more details...
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 3947my 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 7793Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
1 4613we 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 8273i 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 5446in 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 13504in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 10012i 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 11899in 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 6948Post New Informatica Questions
What is a grid in Informatica?
Is it possible to use a client with different version than that of its Informatica server?
What do you mean by blocking transformation?
How can we improve session performance in aggregator transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is depict expression change?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is xml source qualifier transformation in informatica?
What are connected or unconnected transformations?
Explain pmcmd command usage in informatica
Explain in detail scd type 2 through mapping.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How do you handle two sessions in Informatica
