Answer Posted / swetha
Join data originating from same source data base.
Filter records when the informatica server reads source data.
Specify an outer join rather than the default inner join
specify sorted records.
Select only distinct values from the source.
Creating custom query to issue a special SELECT statement
for the informatica server to read source data.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
update strategy transformation in informatica
complex mapping ur project u r invlve can u explain and give real time example give me ?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How do you load only null records into target?
How do we call shell scripts from informatica?
How do you use reject loader.
What are the transformations that are not supported in mapplet?
How can we create index after completion of load process?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Enlist some properties of sessions.
How do you load first and last records into target table?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Describe an informatica powercenter?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is data caches/ index caches?
