What are the tuning techniques you applied during your last
project
No Answer is Posted For this Question
Be the First to Post Answer
wat s mapping parameter and mapping variable? how do you set that in a mapping?
How to do unit testing in informatica?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
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?
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
Difference between session variables and workflow variables?
What is the need for an etl tool?
What are the unsupported repository objects for a mapplet?
what is the size of ur database(like oracle)
Is it possible to have "5 source & 5 Target" in single mapping?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
Major difference between SQL override and Lookup Sql override