Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Data Warehouse Interview Questions
Questions Answers Views Company eMail

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2305

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

HP,

1975

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

HP,

1 3180

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

IBM,

1796

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

Accenture,

1 3413

How do you join more than 3 flat files in informatica?

ITC Infotech,

1 3180

Useful UNIX commands regular/frequently used

Deloitte,

1 4493

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 2537

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1527

what is repositery?

IBM,

1843

Why the workflow is failed after running two hours in informatica?

GE,

1 2852

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1500

if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

Accenture,

1404

What's the difference between VAR A1 - A4 and VAR A1 - A4?

Quintiles,

1 4959


Un-Answered Questions { Data Warehouse }

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2119


If informatica has its scheduler why using third party scheduler?

1268


List few etl bugs?

943


For clinical entire study how many tables will create approx?

1970


What is data stream and data adapter is it same are different? Explain?

970


What are the main services provided by application tier?

981


How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

4400


What is the purpose of indexes?

1074


What are your responsibilities as an etl tester?

1160


What would you change about your job?

2388


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2184


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1719


Briefly describe lookup transformation?

1046


Explain about a tricky situation for which you found a very simple solution?

1007


what is sas metadata server? : Sas-di

1107