Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
2 13186Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
2340I 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 27349I 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 6521Hi, 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 88863. 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 12806What 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
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Does an informatica transformation support only aggregate expressions?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
explain abt ur project architecture?
Which version configuration tool used in ur project?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Why filter transformation is an active one?
What is pmcmd command?
Parameter and variable differences
What are the uses of etl tools?
What do you mean by enterprise data warehousing?
How to load last n records of file into target table - informatica
4 yrs etl devloper roles and responsibilities?any body give solutions
What is a joiner transformation and why it is an active one?
What is informatica metadata and where is it stored?