I have worked on Informatica 7.1.1. I want to know the
answer for the below question.
Target is not created initially.Then how to take the DDL
script from the source and run the Mapping by creating the
Target dynamically?Is it possible by SQL Transformation?
No Answer is Posted For this Question
Be the First to Post Answer
with out using update strategy transnsformation how to update the data in mapping level
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
How does a rank transform differ from aggregator transform functions max and min?
what is dynamic cashe
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
how to convert the .doc docs into .txt format using informatica
Can anyone briefly describe abt audit table loading?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Hi experts, can anyone tell how much we use plsql in real time
What happens to map if we alter the datatypes between source and its corresponding source qualifier?