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 25414TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
6 17484explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
8 34208what is the logic will you implement to load data into a fact table from n dimension tables?
4 17998What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
8 22320How 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 8223How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 34099In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 22470supose 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 13383when 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 14833Post New TCS Informatica Interview Questions
In every bank, why does probationary officer verifies a transaction after entered by the clerk?
What are dataproviders?
What is the java authentication and authorization service (jaas) 1.0?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
Why backlinks are important in seo
What is the use of object recorder?
Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?
What is the meaning of linux shell and shell script?
What is swing in java javatpoint?
What does executereader return?
Can flex applications communicate with each other on the client?
We have fifteen year old CNC turning lathe,placed in dust proof room,recently giving control problems frequently.We are considering to retrofit it.Pl.brief me about various point I should consider for accessing the mechanical health of machine.
What is the use of ‘git log’?
What is q (single q) operator in perl?
Explain the difference between a struct and a class?