I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 120442How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
2 7561if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
5 8792a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
2 6775Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
3 10456write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
1 5321write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
2599if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
2 6359if i have a delimited file as source so how can we seperate this file into three diff targets?
2 5590if the column name in sql override is diff from the column name in source qualifier,what is the impact?
5 9754Post New TCS Informatica Interview Questions
Enlist the basic components of LINUX?
how many test cases do u need to ship a product?
What is the main focus of xsl?
What is a base url?
What does the system tray icon look like?
What is laravel horizon?
why the NGR (neutral grounding resistor) always OFF during DG off?
Is ms word a software?
What is event in web programming?
Does sap make their own imdb/hana hardware?
What is the type of earth fault protection used in battery? explain.
What is SSTable? How is it different from other relational tables?
Explain the concept of the box model in css.
How might you approve all mappings in the archive all the while?
What are the benefits of having a collections management solution powered by sap hana?