iTeachSAP Posted January 21, 2013 Report Posted January 21, 2013 [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is a source qualifier?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is a surrogate key?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is difference between Mapplet and reusable transformation?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is DTM session?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is a Mapplet?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is a look up function? What is default transformation for the look up function?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is difference between a connected look up and unconnected look up?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is up date strategy and what are the options for update strategy?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is subject area?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is the difference between truncate and delete statements?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What kind of Update strategies are normally used (Type 1, 2 & 3) & what are the differences?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is the exact syntax of an update strategy?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What are bitmap indexes and how and why are they used?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is bulk bind? How does it improve performance?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What are the different ways to filter rows using Informatica transformations?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is referential Integrity error? How do you rectify it?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is DTM process?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is target load order?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What exactly is a shortcut and how do you use it?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is a shared folder?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What are the different transformations where you can use a SQL override?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is the difference between a Bulk and Normal mode and where exactly is it defined?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is the difference between Local & Global repository?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What are data driven sessions?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What are the common errors while running a Informatica session?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What are worklets and what is their use?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is change data capture?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What exactly is tracing level?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is the difference between constraints based load ordering and target load plan?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]What is a deployment group and what is its use?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]When and how a partition is defined using Informatica?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How do you improve performance in an Update strategy?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How do you validate all the mappings in the repository at once?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How can you join two or more tables without using the source qualifier override SQL or a Joiner transformation?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How can you define a transformation? What are different types of transformations in Informatica?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How many repositories can be created in Informatica?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How many minimum groups can be defined in a Router transformation?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How do you define partitions in Informatica?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How can you improve performance in an Aggregator transformation?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How does the Informatica know that the input is sorted?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How many worklets can be defined within a workflow?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]How do you define a parameter file? Give an example of its use.[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]If you join two or more tables and then pull out about two columns from each table into the source qualifier and then just pull out one column from the source qualifier into an Expression transformation and then do a ‘generate SQL’ in the source qualifier how many columns will show up in the generated SQL.[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]In a Type 1 mapping with one source and one target table what is the minimum number of update strategy transformations to be used?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]At what levels can you define parameter files and what is the order?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]In a session log file where can you find the reader and the writer details?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]For joining three heterogeneous tables how many joiner transformations are required?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]Can you look up a flat file using Informatica?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]While running a session what default files are created?[/size][/font][/color] [color=#4C5356][font=Arial, Helvetica, sans-serif][size=3]Describe the use of Materialized views and how are they different from a normal view.[/size][/font][/color]
lolliman Posted January 21, 2013 Report Posted January 21, 2013 baa evarinaa dabbulaki job ichee employer vuntee cheppu pleaseeeee
jaffanajeffada Posted January 21, 2013 Report Posted January 21, 2013 SAP tho patu informatica kooda teaching a nuvvu?
iTeachSAP Posted January 21, 2013 Author Report Posted January 21, 2013 [quote name='lolliman' timestamp='1358731696' post='1303142906'] baa evarinaa dabbulaki job ichee employer vuntee cheppu pleaseeeee [/quote] dabbulaki job iche employer aa ? ante enti ardham kaaledhu
iTeachSAP Posted January 21, 2013 Author Report Posted January 21, 2013 [quote name='jaffanajeffada' timestamp='1358731876' post='1303142911'] SAP tho patu informatica kooda teaching a nuvvu? [/quote] naa profile description chudaledhu anamaata nuvvu ..
qwerty1204 Posted January 21, 2013 Report Posted January 21, 2013 GP baa...how hard is for a DataStage developer to learn informatica baa..like ee naming terminologies and all
jaffanajeffada Posted January 21, 2013 Report Posted January 21, 2013 [quote name='iTeachSAP' timestamp='1358732059' post='1303142924'] naa profile description chudaledhu anamaata nuvvu .. [/quote] nuvvu super gaa... nen informatica medha working! adhi okkati nerchukuni jeevithaniki idhi chaalu le ani kaalam gadipestunna!
Terminator II Posted January 21, 2013 Report Posted January 21, 2013 [quote name='jaffanajeffada' timestamp='1358786012' post='1303145740'] nuvvu super gaa... nen informatica medha working! adhi okkati nerchukuni jeevithaniki idhi chaalu le ani kaalam gadipestunna! [/quote] nenu informatica tho patu.. edo okati nerchukundam anukuntunna kani.. jeevitham time vachesariki interest ravatla..
jaffanajeffada Posted January 21, 2013 Report Posted January 21, 2013 [quote name='kevkekaa' timestamp='1358786221' post='1303145758'] nenu informatica tho patu.. edo okati nerchukundam anukuntunna kani.. jeevitham time vachesariki interest ravatla.. [/quote] heehhe adhe baa problem, prastutham job chesthoo life cool ga untundhi ga, kothavi nerchukobuddhi kaadu! time vachinappudu, areree appudu nerchukunte bavundu ani anipistundhi! nuvuv informatica medha working aa?
Terminator II Posted January 21, 2013 Report Posted January 21, 2013 [quote name='jaffanajeffada' timestamp='1358786506' post='1303145774'] heehhe adhe baa problem, prastutham job chesthoo life cool ga untundhi ga, kothavi nerchukobuddhi kaadu! time vachinappudu, areree appudu nerchukunte bavundu ani anipistundhi! nuvuv informatica medha working aa? [/quote] yes
jaffanajeffada Posted January 21, 2013 Report Posted January 21, 2013 [quote name='kevkekaa' timestamp='1358786565' post='1303145779'] yes [/quote] cool... neeku IDQ/MDM lu vacha?
Recommended Posts