Answer Posted / grhyrngnn yjhyj
i used to stored procedure for time conversion,droping and
creating indexes,for loading time dimension,to know the
status of the database,to know the space availble.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
draw informatica architecture 8.6 ?
Differentiate between sessions and batches?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Define mapping and session?
How to create or import flat file definition in to the warehouse designer?
Explain the types of lookup transformation?
Enlist few areas or real-time situations where informatica is required.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is rank transformation?
On which transformations you created partitions in your project?
what is mean by complex business rule ?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How you can differentiate between connected lookup and unconnected lookup?
What are the types of data warehouses?
Scheduling properties,whats the default (sequential)