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 27401TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
6 19432explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
8 36580what is the logic will you implement to load data into a fact table from n dimension tables?
4 19604What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
8 24743How 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 9126How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 37737In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 23731supose 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 14861when 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 17140Post New TCS Informatica Interview Questions
Give a brief idea about jquery mobile? : jQuery Mobile
Differentiate between readfile vs createreadstream in node.js?
What does font family mean?
Do I need a dedicated ip?
How do you view log files in sybase?
why constant voltage transformer should be start without load? and if started then what will happen?
How to concatenate two text values in oracle?
What is Fault Tolerance in Hadoop HDFS?
Why High voltage are generate noise ?
did u p prepared complex report
Explain the difference between comp & comp-3?
How to calculate the cement plastering for circular and rectangular water storage tanks and how to calculate the area of circular and rectangular floor?? Please help me
What is the namespace for creating webservice?
What is b2c and b2b business model?
find the damper capacity of a system having a damping co efficient of 90% with a vibrating mass of 0.1Kg over a spring having a stiffness of 1KN/m.