Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
2 13185Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
2339I have a file with data comming as
1,x1,x2,x3
2,a1,a2
3,b1,b2,b3,b4
1,y1,y2,y3
2,c1,c2,c3
3,d1,d2
my out put should be as follows
x1,x2,x3,a1,a2,
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
7 27341I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
3 6519Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
6 88853. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
7 12800What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
CTS,
2 5975Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
2 6091Post New Informatica Questions
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
To import the flat file definition into the designer where should the flat file be placed?
What are the different clients of powercenter?
In informatica workflow manager, how many repositories can be created?
What is main use of mapplet?
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?
Explain the different lookup methods used in informatica?
Separate from an archive server and a powerhouse?
What's the layout of parameter file (what does a parameter file contain?)?
What is transformation?
how we can load rejected record's at run time?(not through bad files)
can you please explain me pre session and post session options?
How we can use union transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How many types of sessions are there in informatica.please explain them?