I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 120574How 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 7564if 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 8798a 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 6777Can 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 10465write 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 5322write 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
2600if 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 6360if i have a delimited file as source so how can we seperate this file into three diff targets?
2 5593if 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
How would you create your application in DHTML?
What is difference between inner join and join?
What is WP17 Interleaved Parallel Routing?
How to Generate client stubs and server servants?
What do you mean Abstraction in java?
What is spring batch framework?
What is a jsp container?
Testcases for msword( microsoct office word??
y neutal is required for 3 phase. neutral carrys only current or voltage. in 3 phase circuits.
Can private members of a base class are inheritable justify?
Is sybase relational database?
Explain public cloud?
what are the different types of object caches in Neo4j?
What is 'custom duty'?
What’s bluetooth low energy (ble) protocol for internet of factors (iot)?