vijay


{ City } hyderabad
< Country > india
* Profession * software engineer
User No # 32687
Total Questions Posted # 10
Total Answers Posted # 8

Total Answers Posted for My Questions # 64
Total Views for My Questions # 177772

Users Marked my Answers as Correct # 68
Users Marked my Answers as Wrong # 16
Questions / { vijay }
Questions Answers Category Views Company eMail

Hi This is Vijay, How can your remove the duplicates in sequential File?

HCL, Scope International,

15 Data Stage 26742

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

Semantic Space,

8 Data Stage 11268

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

TCS,

5 Data Stage 10836

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

Scope International,

15 Data Stage 29169

Hi Vijay here For Four CPU's how many nodes will required?

TCS,

4 Data Stage 9808

How can you join flat file, oracle as a sources?

IBM,

4 Data Stage 11230

How can you find out whether datastage process is running or not in unix?

Accenture,

3 Data Stage 23780

when will you go for dataset and fileset?

Accenture,

2 Data Stage 13711

how can i abort the job if i get more than 100 errors in job log?

Accenture,

6 Data Stage 22474

wt is the diff b/w odbc and oracle stage

Accenture, HCL,

2 Data Stage 18754



Answers / { vijay }

Question { IBM, 14966 }

how can we extract data with out having any common column


Answer

create a one dummy column in both tables .

like dummy x in t1 table,
dummy x in t2 table.

make a inner join .. then u ll get data from both tables.

Is This Answer Correct ?    13 Yes 2 No

Question { TCS, 27075 }

what is the differeces between hash and modulus partition
methods


Answer

Hi this is Vijay

Modulus Hash

1. For numerics 1. For Numerics and characters
2. Datatype specific 2. Not Datatype spefic

Is This Answer Correct ?    13 Yes 1 No


Question { Satyam, 7745 }

What are the environmental settings for data stage,while
working on parellel jobs?


Answer

Hi Vijay here

Mainly we need 3 Environment variable to run datastage px
job. They are 1. APT_CONFIG_FILE
2. APT_RECORD_COUNT
3. APT_DUMP_SCORE

Is This Answer Correct ?    12 Yes 0 No

Question { Wipro, 21307 }

can we use sequential file as a lookup


Answer

Hi kiran,

pls Explan ur ans.

Is This Answer Correct ?    0 Yes 0 No

Question { TCS, 8925 }

When we will go for Data elements?


Answer

Hi,

Data Elements are nothing but the Datatypes of the
particular column.

If source datatype not mathing with the target column that
time will use. This available in Ds Manager.

Is This Answer Correct ?    2 Yes 1 No

Question { Wipro, 22338 }

With out using Funnel Stage, how to populate the data from
different sources to single target


Answer

Hi Kiran ,

We can populate the sources metadata to target without
using funnel stage using "Seqential File" Stage.

let me explain

In Sequential file we have a property called "File" so first
u give the file name and load the data.

Next time in the same sequential file right side we have a
property "File" just click on that so it will ask another
file name just give other file name ...do not load the data
, in the same you can give how many files u have.

Finally u ran the job Automatically the data will be appended.

Thks

Is This Answer Correct ?    14 Yes 5 No

Question { HCL, 26742 }

Hi This is Vijay,

How can your remove the duplicates in sequential File?


Answer

Hi Kiran My Question is Correct.

How can u remove the duplicate in source file( in
Sequential file stage)?

Is This Answer Correct ?    8 Yes 3 No

Question { IBM, 11230 }

How can you join flat file, oracle as a sources?


Answer

First you convert the data from flat file into oracle , so
now we have two oracle db's then easily we can join these
two sources using join stage.

I have also faced this question at IBM US.

Is This Answer Correct ?    6 Yes 4 No