suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
7 11605There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
9 11976If we are using an aggregator but forget to mention the group by port .what will be the output??
11 30763HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
3 9178What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
5 18354I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
6 13796Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
2 14459Post New TCS Informatica Interview Questions
Which daemon tracks events on your system?
Should I target one word keyword like seo? What is the logic?
selenium can handle pop-up windows based on selenium is a test tool?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the time-dependent workflow – considerations ?
What do you mean by the zone of protection?
What are protocols?
How to run xcode and other tools with the iphone sdk?
Do you need a main function in c++?
In sap script, created 1 form but when its went to production system , client want some changes in 1 (ex - addrss) window, what we will do?
for what purpose would you use the retain statement? : Sas programming
What is final keyword?
‘ C’ PROGRAME TO SHOW THE TYPE OF TRANGLE BY ACCEPTING IT’S LENGTH .
How do organisms adjust to changes in temperature?
What is servlet looping or chaining?