Different types of Power center errors?
Answer / anonymous
https://uisapp2.iu.edu/confluence-prd/display/EDW/PowerCenter+Errors
This link is good.
| Is This Answer Correct ? | 4 Yes | 5 No |
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
r u done any partitions in ur project?
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
How to update a particular record in target with out running whole workflow?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What is a design?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
What is the different lookup cache(s)?
What is meant by lookup transformation?