Data Warehousing - Informatica Experienced Questions

Download as pdf or txt
Download as pdf or txt
You are on page 1of 5

11/18/13

More Next Blog

Data Warehousing: Informatica Experienced Questions


Create Blog

Informatica Real-time Project Scenarios faq's Teradata Oracle


Thi s Bl og i s devel oped to Sha re my knowl edge to the worl d. If a ny s ugges ti ons or comments on thi s bl og gra te pl ea s ure to wel come.

Home

Data Warehousing

INFORMATICA

TERADATA

ORACLE

Interview Zone

DWH Books

Download

SATURDAY, 11 AUGUST 2012

Informatica Experienced Questions


INFORMATICA

SEARCH THIS BLOG

Search
1. Difference between Informatica 7x and 8x? 2. Difference between connected and unconnected lookup transformation in Informatica? 3. Difference between stop and abort in Informatica? 4. Difference between Static and Dynamic caches? 5. W hat is Persistent Lookup cache? What is its significance? 6. Difference between and reusable transformation and mapplet? 7. How the Informatica server sorts the string values in Rank transformation? 8. Is sorter an active or passive transformation? When do we consider it to be active and passive? 9. Explain about Informatica server Architecture? 10. In update strategy Relational table or flat file which gives us more performance? Why? 11. W hat are the out put files that the Informatica server creates during running a session? 12. Can you explain what are error tables in Informatica are and how we do error handling in Informatica? 13. Difference between constraint base loading and target load plan? 14. Difference between IIF and DECODE function? 15. How to import oracle sequence into Informatica? 16. W hat is parameter file? 17. Difference between Normal load and Bulk load? 18. How u will create header and footer in target using Informatica? 19. W hat are the session parameters? 20. W here does Informatica store rejected data? How do we view them?
UNIX TRANSLATE TO UR LANGUAGE

Informa ti ca (3) Informa ti ca Compl ete Reference (1) Informa ti ca Functi ons (1) Informa ti ca Powercenter Archi tecture (1) i nforma ti ca project (1) Informa ti ca Qui es ti ons (1) Informa ti ca Qui es ti ons 3 (1) Informa ti ca Rea l ti me Scena ri os (1) Informa ti ca s cena ri os (3) Integra ti on Tes ti ng (1)

SMS

Select Language

TERADATA

Tera da ta (33) Tera da ta La tes t FAQ's (1) Tera da ta ma i n (1) Tera da ta SQL a s s i s ta nt (1)

ORACLE

Ora cl e (1) Ora cl e Queri es (1) PL/SQL (2) PL/SQL Excepti on (1) PL/SQL Loopi ng (1) SQL Queri es (2)

TOTAL PAGEVIEWS

211,959
MOTHER TERESA QUOTES

21. W hat is difference between partitioning of relational target and file targets? 22. W hat are mapping parameters and variables in which situation we can use them? 23. W hat do you mean by direct loading and Indirect loading in session properties?

Archi tecture of UNIX (1) Ba s i c Uni x Comma nds (1) Funda menta l s of UNIX (1) Uni x (2)

Do not wait for leaders; do it alone, person to person. ..................................... Mother Teresa

24. How do we implement recovery strategy while running concurrent batches? 25. Explain the versioning concept in Informatica? 26. 26.W hat is Data driven? 27.W hat is batch? Explain the types of the batches? 28.W hat are the types of meta data repository stores? 29.Can you use the mapping parameters or variables created in one mapping into another mapping? 30.W hy did we use stored procedure in our ETL Application? 31.W hen we can join tables at the Source qualifier itself, why do we go for joiner transformation? 32.W hat is the default join operation performed by the look up transformation? 33.W hat is hash table Informatica? 34.In a joiner transformation, you should specify the table with lesser rows as the master table. Why? 35.Difference between Cached lookup and Un-cached lookup?

CONTACT ME ON SKYPE DATAWAREHOUSING-KAREEM

Subscribe via Email


Enter email
Submit

ADS 468X60PX

informatica-kareem.blogspot.in/2012/08/informatica-experienced-questions.html

1/5

11/18/13
SOCIAL ICONS

Data Warehousing: Informatica Experienced Questions


36.Explain what DTM does when you start a work flow? 37.Explain what Load Manager does when you start a work flow? 38.In a Sequential batch how do i stop one particular session from running? 39.W hat are the types of the aggregations available in Informatica? 40.How do I create Indexes after the load process is done? 41.How do we improve the performance of the aggregator transformation? 42.W hat are the different types of the caches available in Informatica? Data Warehouse Explain in detail?

pow ered by

Data Warehouse
Like 71

43.W hat is polling?

Like

71the people like Data Warehouse. 44.W hat are the limitations of joiner transformation?

45.W hat is Mapplet? 46.W hat are active and passive transformations? 47.W hat are the options in the target session of update strategy transformation?
RECENT POSTS

FOLLOWERS

Join this site


w ith Google Friend Connect

Members (35) More

48.W hat is a code page? Explain the types of the code pages? 49.W hat do you mean rank cache? 50.How can you delete duplicate rows with out using Dynamic Lookup? Tell me any other ways using lookup delete the duplicate rows?
By Data Warehousing / +Get This!

Da ta Wa rehous i ng PL/SQL Records Wha t a re records ? Records a re a nother type of da ta types PL/SQL Cons ta nts As the na me i mpl i es a cons ta nt i s a va l ue us ed Impl ementi ng Informa ti ca Pers i s tent Ca che You mus t ha ve noti ced tha t the "ti me" Informa ti ca ta kes Informa ti ca Us er Defi ned Functi ons Informa ti ca Us er Defi ned Functi ons a re s i mi l a r to Bui l t-i n Functi ons , Informa ti ca Performa nce Improvement Ti ps We often come a cros s s i tua ti ons where Da ta Tra ns forma ti on Ma na ger Informa ti ca Devel opment Bes t Pra cti ces Ma ppi ng The fol l owi ng a re genera l l y a ccepted Bes t Pra cti ces for Informa ti ca

Already a member? Sign in Posted by Kareem M at Saturday, August 11, 2012 Recommend this on Google SUBSCRIBE TO

Pos ts

No comments: Post a Comment


Tha nks for your Comments , @ka reem

Comments

FEEDJIT

Live Traffic Feed

Enter your comment...

Comment as:
POPULAR POSTS

Google Account

Welcome to KAREEM's Blog


Publish Preview

The Compl ete Informa ti ca Tutori a l Ins ta l l a ti on of Informa ti ca Informa ti ca power center 8.6 Ins ta l l a ti on Informa ti ca Power Cente... INFORMATICA SCENARIOS INFORMATICA SCENARIOS 1. How to genera te s equence numbers us i ng expres s i on tra ns forma ti on? 2. Des i gn a ma ppi ng to l oa d the fi rs t 3... Wha t i s i nforma ti ca I nforma ti ca Power Center i s a powerful ETL tool from Informa ti ca Corpora ti on. Informa ti ca Corpora ti on products a re: Informa ti ca Power Ce... Al l Downl oa ds Cl i ck the bel ow l i nks to downl oa d.. Informa ti ca Qui es ti on Ba nk Informa ti ca Qui es ti on Ba nk2 Ta l l y 9.0 Tera da ta Rea l ti me Qui es ti ... Da ta Wa rehous i ng Da ta Wa rehous i ng Wha t i s Da ta Wa rehous e? DWH Model i ng Da ta Wa rehous e Schema s Da ta wa rehous i ng Qui es ti ons 1 Da ta ... Informa ti ca Compl ete Reference Informa ti ca Rea l -ti me Project [ETL] Wha t i s

Links to this post


Crea te a Li nk

A visitor from Hyderabad, Andhra Pradesh viewed "Data Warehousing: Informatica scenarios" 31 mins ago A visitor from Daytona Beach, Florida viewed "Data Warehousing" 41 mins ago A visitor from India viewed "Data Warehousing: Teradata" 51 mins ago A visitor from Daytona Beach, Florida viewed "Data Warehousing" 1 hour 14 mins ago A visitor from India viewed "Data Warehousing: The Complete Informatica Tutorial" 1 hour 45 mins ago A visitor from Hyderabad, Andhra Pradesh viewed "Data Warehousing" 2 hours 2 mins ago
BLOG ARCHIVE

2013 (92) 2012 (256) December (108) November (28) October (14) Newer Pos t Subs cri be to: Pos t Comments (Atom) Home Ol der Pos t Augus t (106) Informa ti ca Powercenter Archi tecture Informa ti ca Project
Informatica (3) Informatica scenarios (3) Data warehousing Quiestions (2) Locking

LABELS

Teradata (33)

table for access? (2) PL/SQL (2) SQL Queries (2) Unix (2) AUGUST 15th (1) Architecture of UNIX (1) Basic Unix Commands
(1) Constraint-Based Loading (1) Data Warehouse Schemas (1) Data warehousing Quiestions1 (1) Debugger (1) Downloads (1) ETL Process (1) Fundamentals of UNIX (1) Get top 5 records to target without using rank (1) Home (1) How do you perform

Convert Numeri c Va l ue to Da te Forma t Sena ri o:Suppo... Currency convertor

informatica-kareem.blogspot.in/2012/08/informatica-experienced-questions.html

2/5

11/18/13
Informa ti ca ? Tra ns forma ti ons i n Informa ti ca 9 ....La tes t Informa ti ca Tuni ng - Step b...

Data Warehousing: Informatica Experienced Questions


incremental logic or Delta or CDC (1) Incremental Loading for Dimension Table (1) Informatica Complete Reference (1) Informatica Functions (1) Informatica Powercenter Architecture (1) Informatica Quiestions (1) Informatica Quiestions3 (1) Informatica Real time Scenarios (1) Integration Testing (1) Introduction of Unix (1) Oracle (1) Oracle Queries (1) PL/SQL Exception (1) PL/SQL Looping (1) PL/SQL Programs (1) Power center Client (1) Separate rows on group basis (1) TESTING-User Acceptance Test (1) Target Load Order (1) Teradata Latest FAQ's (1) Teradata SQL assistant (1) Teradata main (1) Unit Testing (1) What is informatica (1) informatica project (1) Recent Posts Widget | Webaholic

Suppos e tha t a s ource conta i ns ... Da te Di fference i n Hours Scena ri o:There i s a order... How do you perform i ncrementa l l ogi c or Del ta or C... Sepa ra te rows on group ba s i s In Dept ta bl e there a ... Get top 5 records to ta rget wi thout us i ng ra nk How... Informa ti ca Compl ete Reference Mera BHARATH ko SALAM... Uni t Tes ti ng Integra ti on Tes ti ng Us er Accepta nce Tes t Debugger Cons tra i nt-Ba s ed Loa di ng Ta rget Loa d Order Incrementa l Loa di ng for Di mens i on Ta bl e Da ta Wa rehous e Schema s PL/SQL Excepti on PL/SQL Loopi ng PL/SQL Progra ms PL/SQL PL/SQL Introducti on of Uni x Ba s i c Uni x Comma nds Archi tecture of UNIX Informa ti ca Rea l ti me Scena ri os Informa ti ca Functi ons Informa ti ca Experi enced Ques ti ons Informa ti ca Experi enced Ques ti ons Informa ti ca rea l ti me Intervi ew Qui es ti ons Steps to i ns ta l l Informa ti ca Power Center Server 8... Di fference between 7.1 a nd 8.6 Power center Admi n Cons ol e Informa ti ca Server Proces s Power center Cl i ent ETL-Li fe Cycl e Wha t i s i nforma ti ca Tera da ta Archi tecture a nd Components Wha t a re the ba s i c rul es tha t defi ne how PI i s de... Wha t a re the ba s i c cri teri a to s el ect Pri ma ry Ind... Wha t a re the di fferent return codes (s everi ty erro... Wha t a re perma nent journa l s i n tera da ta ? - Journa l ... Wha t i s the di fference between Mul ti Loa d & Fa s tl o... Wha t i s a cl i que? A cl i que i s a s et of Tera da ta n... How Tera da ta ma kes s ure tha t there a re no dupl i ca ...

informatica-kareem.blogspot.in/2012/08/informatica-experienced-questions.html

3/5

11/18/13

Data Warehousing: Informatica Experienced Questions


How to vi ew every col umn a nd the col umns conta i ne... How to s el ect fi rs t N Records i n Tera da ta ? How to... Where does TD s tore tra ns i ent journa l ? Where does ... Wha t a re the a dva nta ges a nd di s a dva nta ges of s ec... How ma ny error ta bl es a re there i n fl oa d a nd Ml oa ... Wha t a re perma nent journa l s i n tera da ta ? - Journa l ... Wha t a re the opti ons not a va i l a bl e for vol a ti l e t... Wha t a re the opti ons tha t a re not a va i l a bl e for g... Why i s BTET tra ns a cti on proces s i ng overhea d i n Te... Informa ti ca Qui es ti ons Informa ti ca Qui es ti ons Uni x Tutori a l s Al l Downl oa ds The Compl ete Tera da ta How to check for ta bl e s i ze i n Tera da ta How ca n you vi ew Da ta Di s tri buti on i n Tera da ta ? How to s pl i t s ource col umn i nto mul ti pl e ta rget co... Purpos e of CASESPECIFIC i n tera da ta Ma teri a l i s ed vi ew i n tera da ta ? Is i t pos s i bl e? How to Convert col umn da ta to rows i n tera da ta whi ch i s fa s ter ? s el ect * from ta bl e or s el ect 'a ... Ca n i Genera te ra ndom numbers i n Tera da ta ? Fi nd col umn type us i ng bui l t i n functi on!!! Worki ng a round wi th Tra ns pos i ti on of Ta bl e da ta Tera da ta HELP comma nds Di s ti nct vs group by i n Tera da ta Di s ti nct vs group by i n Tera da ta . Di fference between Crea te ta bl e (copy) a nd Crea te ... Li s t of us eful Da ta di cti ona ry vi ews Li s t of us eful Da ta di cti ona ry vi ews Di fference between count(*) a nd count(1) ? How to Export wi thout junk cha ra cters i n Fa s tExpor... Tera da ta Ti ps a nd FAQ's Tera da ta SQL a s s i s ta nt Informa ti ca Rea l ti me Scena ri os Da ta Wa rehous i ng Intervi ew Qui es ti ons Uni x Ba s i c Comma nds Performa nce tuni ng

informatica-kareem.blogspot.in/2012/08/informatica-experienced-questions.html

4/5

11/18/13

Data Warehousing: Informatica Experienced Questions


Tri ggers Curs or Sequence VIEWS JOINS Cons tra i nts Sub Queri es Bui l t i n Functi ons In Ora cl e Group by /Order by / Ha vi ng Cl a us e Ora cl e da ta types Ora cl e Ora cl e Queri es Ora cl e Queri es Hi to a l l ... Ora cl e Intervi ew Qui es ti ons Uni x Funda menta l s Da ta wa rehous i ng Qui es ti ons 1 Da ta wa rehous i ng Qui es ti ons Informa ti ca Procs s Introcti on to Informa ti ca Da ta Wa rehous e hi

NEWTON'S THIRD LAW FOR EVERY ACTION THERE IS AN EQUAL AND OPPOSITE REACTION.

Copy ri ghts @Da ta Wa rehous i ng. Templ a te i ma ges by merrymoonma ry. Powered by Bl ogger.

Twi tter Bi rd Ga dget

informatica-kareem.blogspot.in/2012/08/informatica-experienced-questions.html

5/5

You might also like