I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 117621How 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 7446if 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 8646a 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 6670Can 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 10348write 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 5213write 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
2554if 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 6278if i have a delimited file as source so how can we seperate this file into three diff targets?
2 5483if the column name in sql override is diff from the column name in source qualifier,what is the impact?
5 9600Post New TCS Informatica Interview Questions
Explain the architecture of iphone? : IOS Architect
Explain the difference between service & intent service?
What are intelligent cubes?
What are the different ways to login to a remote server? Explain the me, advantages and disadvantages?
Distribution transformer we provided 2 separate earthing pit for Body and 2 separate earthing pit for neutral,we can not connect separate body earthing pit to other earthing pit but we do metal glanding in secondary side cable termination in both side, transformer and PCC panel (LT Panel), is this safe for transformer and other equipment?
What is the normalization?
Explain the main difference between a bird heart and a mammalian heart?
Describe a project you've worked on and how it made a difference.
How to send an email using siebel application? Other than using f9 functional key?
What is the rattle package in r?
Tell about dvat and dvat rate
What is the earths crust made of?
What are some python projects for beginners?
Why do sausages split lengthways, rather than around the circumference?
What is ejb in java with example?