Can a joiner be used in a mapplet.
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
What is native users?
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?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
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
What are the various types of transformation?
Where is metadata stored?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what is threshold error in informatica?
How can you define a transformation? What are different types of transformations in Informatica?
What are the tasks that Loadmanger process will do?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use