If we are using an aggregator but forget to mention the group by port .what will be the output??
11 30596I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
4 9315If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
9 13470Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
5 10144Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
1 6149I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
3 6895HOw 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.....
TCS,
3 9138Post New Informatica Questions
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can we use mapping variables in informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is source qualifier transformation in informatica?
Explain what is informatica metadata and where is it stored?
What are the advantages of informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What do you mean by blocking transformation?
How do you load only null records into target? Explain through mapping flow.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is pmcmd command?