Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
2 13313Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
2410I 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 27572I 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 6659Hi, 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 91153. 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 13032What 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 6085Is 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 6207Post New Informatica Questions
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is workflow? What are the components of the workflow manager?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Mention few power centre client applications with their basic purpose?
Separate from an archive server and a powerhouse?
Whats there in global repository
Explain the different dimensions.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the differences between a connected lookup and unconnected lookup?
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?
Please let me know how to make Data masking in informatica..
What do mean by local and global repository?
What is target load order?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
