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 13191

,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 8008

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 6379

what is curr val use for in sequence generator?

Emphasis,

2 7556

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 4857

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

Emphasis,

2 6315

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

Emphasis, JBL, Wipro,

2 10254

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 11839

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

Bodhtree, HP,

2 15423

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 9691

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,

2244

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 11665

HOW TO PUBLISH A REPORT IN BO?

Polaris,

1 7130

-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 5791

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

TCS,

4 7488


Un-Answered Questions { Data Warehouse }

Write the advantages of partitioning a session?

1282


What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1038


How were the reports scheduled and how to resolve unexecuted documents?

2674


What is a joiner transformation?

996


What is the SAS data set?

1129


What is the sas data set? : sas-grid-administration

985


How to get the first 100 rows from the flat file into the target?

1210


What are the different types of parallelism used in abinitio?

1111


how to insert/update a csv file by comparing it with another csv file?

2568


How do you convert single row from source into three rows into target?

1157


update strategy transformation in informatica

1064


what is ds administrator used for?

1170


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2267


what is difference between drill & scope of analysis?

1091


How far Redshift is better in performance as compare to other data warehouse technologies?

5