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

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

IBM,

4 13346

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

Emphasis,

3 8160

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

Emphasis,

2 6478

what is curr val use for in sequence generator?

Emphasis,

2 7691

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

Emphasis,

1 4958

what is the necessity to use update strategy?(except for updates)

Emphasis,

2 6444

What is the method of seperating unique and duplicate records in session level?

Emphasis, JBL, Wipro,

2 10360

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

Accenture,

6 12033

what is the difference between a data item and a query item?

Bodhtree, HP,

2 15625

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 9889

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

IBM,

2299

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

IBM,

5 11836

HOW TO PUBLISH A REPORT IN BO?

Polaris,

1 7208

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

TCS,

1 5886

How do you find what type of trap is there by seeing the report?

TCS,

4 7696


Un-Answered Questions { Data Warehouse }

how do you test for missing values? : Sas programming

1102


Differentiate between datastage and informatica?

1251


what is the meaning of upgradation of Repository?

3802


What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

1312


What is workflow? What are the components of workflow manager?

1235


What is meant by a Clique?

1118


complex mapping ur project u r invlve can u explain and give real time example give me ?

2353


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2522


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2175


10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?

2554


What are the steps to create a repository in ab initio?

1308


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2074


What are the different ways to implement parallel processing in informatica?

1491


Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

1100


what is flow of project?

2061