Interested to Buy Any Domain ? << Click Here >> for more details...
what is the significance of newlookup port in dynamic look up
- 1 Answers
- 6434 Views
- IBM, I also Faced
- E-Mail Answers
When we configure a look up t/r to use a dynamic cache, the
designer automatically adds a port called "New Lookup Row"
to the look up t/r. This port indicates with a numeric value
whether the Informatica server inserts or updates the row in
the cache or makes no change in the cache.
To keep the lookup cache and the target table
synchronised, we pass rows to the target when the New Lookup
Row value is equal to 1 or 2.
| Is This Answer Correct ? | 5 Yes | 0 No |
How can i send first half of the records to one target and Remaining to other target?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
What are the different threads in DTM process?
What do mean by local and global repository?
What is a unit Testing?
How you prepared reports for OLAP?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
What is blocking transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
Teradata 
