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, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

HCL,

1 7241

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

Accenture, Gcs, TCS,

119 121575

how to join two flat files in informatica?

Wipro,

3 19319

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

Wipro,

4 9678

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

Wipro,

5 9910

in what type of scenario bulk loading and normal loading we use?

Cognizant, Wipro,

2 6899

how can we run workflow with pmcmd?

Wipro,

3 9034

what is bridge tables in informatica

CTS,

1 10077

what is the -ve test case in your project.

CTS, TCS,

1 2469

how to retrive the max(sal),deptno,empno in datastage?

Polaris,

13 24963

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

Polaris,

10 17528

Can any body suggest me that Drill through of packages is possible? If yes, how it can be done?

1 5468

im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?

IBM,

6 10183

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

Accenture,

3 23949

why union transformation is active transformation?

IndiGo, TCS,

6 24529


Un-Answered Questions { Data Warehouse }

Write the unconnected lookup syntax and how to return more than one column.

1164


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


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

4011


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2759


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

1224


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2790


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2305


What is aggregate table and aggregate fact table ... Any examples of both?

1113


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


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2298


explain in detail about type 3?

1078


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4183


What is node? How many nodes and amps used in your previous project?

1167


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8274


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

2122