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 is the function in Transformer stage can act as Rank function in Oracle

Reliance,

1 14634

how can we send even and odd records from a sequential file to two different targets

IBM, iGate, TCS,

10 35194

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

Reliance,

1 5884

why we use parameters instead of hard code in datastage

HCL,

4 13599

which memory is used by lookup and join

IBM,

5 13117

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

Accenture, Cognizant,

5 16911

what is dynamic cashe

Informatica,

3 7053

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

Target,

4 23807

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

Cap Gemini, IBM,

10 20406

give me scenario on cascading prompts&master-detail relation

IBM,

4 18294

if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??

Accenture,

6 11718

is it possible to generate sas datasets using proc print ???

GSK GlaxoSmithKline,

1 6958

what are all the ways to define macro variable??

GSK GlaxoSmithKline,

2 7359

what are all the default values getting in PROC MEANS...???

2 6264

What type of tables you are using in YOUR reporting..???

GSK GlaxoSmithKline,

2 6451


Un-Answered Questions { Data Warehouse }

Write the unconnected lookup syntax?

1139


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1231


How do you remove duplicate records in informatica? And how many ways are there to do it?

1224


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2081


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1193


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2338


Hi, If anyone has base SAS certification dumps, please share.

1932


Are you involved in writing the inferential analysis plan? Tables specifications?

4011


can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324


what are the data modeling tools you have used?(polaris)

2054


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122


Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1093


Explain scd type 3 through mapping.

1065


How would you format some text using css to be verdana and bold?

1133


Explain about a time when you discovered a more efficient way to do a work task?

1214