1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 27645TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
6 19730explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
8 36945what is the logic will you implement to load data into a fact table from n dimension tables?
4 19817What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
8 25068How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
2 9268How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 38237In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 23888supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
4 15049when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
7 17431Post New TCS Informatica Interview Questions
What are cleansing packages?
can anyone give an idea about dia calculation in cold rolling mill
What is replication server? What is its role in sybase?
Is it possible for a WCF service to implement Multiple service contracts?
Explain why their is need of production version ?
What situations might be viewed as ethical uses of human cloning? Are you doubtful, fearful, or hopeful about human cloning?
What are scheduled tasks in sql server?
What are the advantages of linked list?
What is a method in java?
What is windows phone media support?
Why HDFS stores data using commodity hardware despite the higher chance of failures?
Explain the use of with statement?
Explain in brief artificial intelligence?
Explain the difference between data reader and data set?
Write a servlet to upload file on server.