21)What is informatica?uses in real world?
1)Informatica is an ETL tool used in DWH concept.
2)It keeps historical data.
3)So all those organizations who wants to keep their all data i.e.updated and historical too can use it.
22)How to fasten loading of 100 million distinct records in informatica?
1)Partition
2)select bulk mode but must to drop index on target before use bulk mode.
3)once load complete then again create index on target.
23)what is data driven in update strategy transformation?(paypal)
Data driven is a set of rules.based upon this rules the
integration service perfoms all operations in update
strategy transformation.
DD_INSERT
DD_UPDATE
DD_REJECT
DD_DELETE
24)How do you connect to remote server ?(patni)
Using FTP through Putty/command prompt.
25)How can we reset Sequence Generator, when we move objects from Dev Environment to QA Environment?(tcs)
Update the current value in the sequence generator to start
the sequence from the beginning again. And click on reset option in transformation.
1)Informatica is an ETL tool used in DWH concept.
2)It keeps historical data.
3)So all those organizations who wants to keep their all data i.e.updated and historical too can use it.
22)How to fasten loading of 100 million distinct records in informatica?
1)Partition
2)select bulk mode but must to drop index on target before use bulk mode.
3)once load complete then again create index on target.
23)what is data driven in update strategy transformation?(paypal)
Data driven is a set of rules.based upon this rules the
integration service perfoms all operations in update
strategy transformation.
DD_INSERT
DD_UPDATE
DD_REJECT
DD_DELETE
24)How do you connect to remote server ?(patni)
Using FTP through Putty/command prompt.
25)How can we reset Sequence Generator, when we move objects from Dev Environment to QA Environment?(tcs)
Update the current value in the sequence generator to start
the sequence from the beginning again. And click on reset option in transformation.
Wow amazing i saw the article with execution models you had posted. It was such informative. Really its a wonderful article. Thank you for sharing and please keep update like this type of article because i want to learn more relevant to this topic.
ReplyDeleteHadoop Training in Chennai
Base SAS Training in Chennai
MSBI Training in Chennai