I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 114264How 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 7315if 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 8409a 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 6553Can 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 10181write 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 5122write 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
2511if 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 6169if i have a delimited file as source so how can we seperate this file into three diff targets?
2 5342if the column name in sql override is diff from the column name in source qualifier,what is the impact?
5 9391Post New TCS Informatica Interview Questions
In which language, angularjs is written?
What is polymorphism and types?
What is purpose of ms excel?
what is the trouble in DNA plasmid extraction ?
How can one access the web service class method via internet?
What is an rss email?
where do we store all custom programs in SD module?
Explain the different types of joins in SAP HANA?
what is the difference between sap and sas?
How do you isolate the various bioactive ingredients from a plant extract?
What is the use of ms word in education?
How to create a user to access a database in ms sql server using "create user" statements?
What is Row Key?
Explain immunoglobulin (ig) a?
How we will do DataBase testing through Qtp application, i know two things 1)Import date from sheet2)Database Check points. But Interviewr asked me How to Run Queries from Qtp Application?Plz Any Body Exlain about Data Base Testing.Urgent.........Advanced Thanks