Mention a few design and development best practices for informatica?
No Answer is Posted For this Question
Be the First to Post Answer
What is a taget load order?
What is workflow monitor?
how u know when to use a static cache and dynamic cache in lookup transformation.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
If I have a index defined on target table and if set it to bulk load will it work ?
What is parameter file?
Which is the t/r that builts only single cache memory?