What is the Environment Variable need to Set to TRIM in
Project Level?(In transfermer, we TRIM function but I need
to impliment this project level using Environment variable)
Input Data is:
Emp_Id, EmpInd
100, 0
100, 0
100, 0
101, 1
101, 1
102, 0
102, 0
102, 1
103, 1
103, 1
I want Output
100, 0
100, 0
100, 0
101, 1
101, 1
Means Indicator should either all ZEROs or all ONEs per
EmpId.
Impliment this using SQL and DataStage both.
Is there no issue when you try to convert a NOt null column
in nullable and vice versa in aggregator styage and
transformer stage? When I tried i got the warnings but in a
running code I can see such type of scenarios. Please
explain
A table containg 100 records B table containg 20 records we
have to join two tables in left outer it containg target 100
records but target containg 101 record at that time what is
the issue arise
Hi Every one,
I have a scenario plz suggest me
1)On daily we r getting some huge files data so all files
metadata is same we have to load in to target table how we
can load?
2) One column having 10 records at run time we have to send
5th and 6th record to target at run time how we can send?
Hi plz help me for above scenarios and If any one is having
JobSequence kindly send me one example and the scenario to
my mail ID(nrvdwh@gmail.com)
Source Like
department_no, employee_name
----------------------------
20, R
10, A
10, D
20, P
10, B
10, C
20, Q
20, S
and Output should be like this
department_no, employee_list
--------------------------------
10, A
10, A,B
10, A,B,C
10, A,B,C,D
20, A,B,C,D,P
20, A,B,C,D,P,Q
20, A,B,C,D,P,Q,R
20, A,B,C,D,P,Q,R,S
8000 jobs r there i given commit, suddenly job will abort?
what happens?
2)diff b/t transformer stage & filter stage?
3)how to load the data in the source?
1.what is repartionoing technique?
2.what deliverables transferred to client using datastage?
3.how to write loop statements using nested loop sequence?
A flat file contains 200 records. I want to load first 50
records at first time running the job, second 50 records at
second time running and so on, how u can develop this job?
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)
if i have two tables
table1 table2
1a 1a,b,c,d
1b 2a,b,c,d,e
1c
1d
2a
2b
2c
2d
2e
how can i get data as same as in tables?
how can i implement scd typ1 and type2 in both server and
in parallel?
field1 field2 field3
suresh , 10,324 , 355 , 1234
ram , 23,456 , 450 , 456
balu ,40,346,23 , 275, 5678
how to remove the duplicate rows,inthe fields?
1)How will u implement SCD2 by using surrogate key.
2)What are the disadvantages with surrogate key.
3)How will you handle nulls in your project for the
varchar, integer data types.
4)Can I use two fact tables in star schema.
5)3 jobs are running on the 2 nodes after I added one more
node so can I compile those jobs to run on three nodes.
358
Anyone has Datastage certification free dumps for 000-418 ,
000-421 codes, mail me @ manik.dwh@gmail.com
000-418 : InfoSphere DataStage v8.0
000-421 : InfoSphere DataStage v8.5
Login
| Sign Up
SiteMap shows list of All Categories in this site.
Site Map
