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?
No Answer is Posted For this Question
Be the First to Post Answer
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
my source is junk data how will u remove that junk data by using unix please any one replay me
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
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
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is exclusive and normal mode for repository services?
how can we load starting with 11th record of a table from source to target
Which development components of informatica have the highest usage?
During the running session, output files are created by informatica server. Enlist few of them.
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
What is log file,and where is it located,why u r using the log file