How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
What is the difference between writing a joiner query in ANSI style and THETA style?
Why we select the table which has minimum number of records as Master table in joiner?4 14503
what is the predefined port in dynamic lookup2 4090
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 42 5007
can any one give some examples for pre sql and post sql(Except dropping and creating index).3031
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me1117
What are mapplets?
What is transformation?
What are the restrictions of union transformation?
What are different types of transformations available in informatica?
What is a dimensional model?
Define Pmrep command?
What is primary and backup node?
whats the logic to load the lower level of granularity of data to fact table.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you update the records with or without using update strategy?
What are the popular informatica products?
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?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Where do we use mapping variables in informatica?