DataStage Scenario based Interview Questions

In one flat file i got headers and lines data how you can write control file now ?

KPMG,

Create an Excel file and pass the values from Flat File? (for ex:data1.txt,data2.txt )

FIS,

where we do database testing in real time project ? and how ...??

I have 2 blocks in my report.2nd block is below the 1st block.in future when I add data to the 1st block it overlaps with 2nd block.i don't want this.i want when 1st block increases with data 2nd block come below 1st block.what you will do to achive this?

HP,

I have cube.for cube data coming from 3dso's.in one dso having special chars.in cube you got special char error.how u can resolve this?

Mind Tree, XYZ,

if we are working on web app and suddenly web app server crush or block ..that situation wht will we do.. and which command will use in sql database

IBM,

Question 62 – The names of the flow streams could be represented by : H1 for first hot stream, H2 for second hot stream, C1 for first cold stream, C2 for second cold stream. Data of supply temperature Ts in degree Celsius : 150 for H1, 170 for H2, 30 for C1, 30 for C2. Data of target temperature Tt in degree Celsius : 50 for H1, 169 for H2, 150 for C1, 40 for C2. Data of heat capacity Cp in kW / degree Celsius : 3 for H1, 360 for H2, 3 for C1, 30 for C2. (a) Find the enthalpy changes, dH for all streams of flow H1, H2, C1 and C2 in the unit of kW. Take note of the formula dH = (Cp) (Tt - Ts). (b) Match the hot streams H1 and H2 with the suitable cold streams C1 and C2 to achieve the maximum energy efficiency.

if i have a query as flat file how can we load data to target table

Tech Mahindra,

I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?

Rockwell, TCS,

I have 10 cubes I created multiprovider I want only 1 cube data what u do?

Rockwell, TCS,

In compression level all requests are becoming zero which data is compressing tell me detail

Rockwell, TCS,

I don't have master data it will possible to load transaction data? it is possible is there any other steps to do that one

Rockwell, TCS,

how can we increase data packet size

Rockwell, TCS,

Question 67 – In order to predict the wastewater production, the population number has to be understood. The population data is : 72000 (for year 1961 or P-1961), 85000 (for year 1971 or P-1971), 110500 (for year 1981 or P-1981). (a) Find the average population increase, or [ (P-1981 - P-1971) + (P-1971 - P-1961) ] / 2. (b) Find the average percentage population increase, or [ (P-1981 - P-1971) / P-1971 + (P-1971 - P-1961) / P-1961 ] / (2) X 100. (c) Find the incremental increase or P-1981 - 2 (P-1971) + P-1961. (d) Let Po = P-1981. After 2 decades or n = 2, the population is P-2001. By using arithmetical increase method, find P-2001 = Po + n (Answer for a). (e) By using incremental increase method, find P-2001 = (Answer of d) + n (n + 1) (Answer of c) / 2. (f) By using geometrical increase method, find P-2001 = Po [ 1 + (Answer of b) / 100 ] ^ n where ^ is power sign, or 1 ^ 2 = 1 x 1 = 1. (g) If the actual P-2001 = 184000, which method of estimation is more accurate, based on your answer in (d), (e) and (f)?