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 27789TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
6 19938explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
8 37200what is the logic will you implement to load data into a fact table from n dimension tables?
4 19970What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
8 25313How 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 9376How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 38594In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 23996supose 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 15212when 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 17621Post New TCS Informatica Interview Questions
Can you explain snc in sap security?
How to write sql script in postgresql?
How can we check whether namenode is working or not?
Can you store different types in an array?
Can a private virtual method can be overridden?
Do python arrays start at 0 or 1?
For linear regression, what are some of the assumptions a data scientist is most likely to make?
Explain "beforesend(xhr)" paremeter of jquery ajax method?
what are the interviews questions for storage domain
What is sort order?
Can I stop a windows update in progress?
why the signals of wireless in db value
What configuration required in mm module for refurbishment process?
How do you delete a table?
Can I use the getattribute() and setattribute() methods of version 2.2 of the java servlet api to parse xml documents? : BEA Weblogic