Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

varaprasad


{ City } ap
< Country > india
* Profession *
User No # 43606
Total Questions Posted # 28
Total Answers Posted # 8

Total Answers Posted for My Questions # 83
Total Views for My Questions # 186435

Users Marked my Answers as Correct # 12
Users Marked my Answers as Wrong # 7
Questions / { varaprasad }
Questions Answers Category Views Company eMail

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

Gallega, TCS,

5 Data Stage 10903

how to sort records in sql?

3 SQL PLSQL 5088

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

Cap Gemini,

5 Data Stage 11243

how to create document in datastage?

Cap Gemini,

1 Data Stage 4995

how to transfer file from one system to another system in unix? which cmd to be use?

Cap Gemini,

5 Data Stage 11515

when u face critical situation in ur project, how to solve them?

Toyota,

1 Data Stage 8698

how to cleansing data

Cap Gemini,

6 Data Stage 12957

A flatfile 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 the job?pls give the steps?

TCS,

3 Data Stage 7368

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

TCS,

1 Data Stage 4977

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

Hexaware,

1 Data Stage 4593

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

TCS,

4 Data Stage 7332

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

HCL,

Data Stage 1367

hw will u use awk in replacing cahrs and files

Unix Commands 2341

1)Source file contains one record, I want 100 records in target file.

3 Data Stage 6518

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Data Stage 5810




 [1]   2    Next



Answers / { varaprasad }

Question { TCS, 22844 }

if we create a file, in that 10 rows(means 1,2,....9,10
like). i want 7 row exactly, which command use in unix?
plz send this question.


Answer

hi isha,

this is prasad, head command displays first n lines from
the file

head -7 it displays first 7 lines, i want exact
7 line.


thanku for send this question isha.

Is This Answer Correct ?    7 Yes 4 No

Question { TCS, 22844 }

if we create a file, in that 10 rows(means 1,2,....9,10
like). i want 7 row exactly, which command use in unix?
plz send this question.


Answer

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

Is This Answer Correct ?    0 Yes 2 No


Question { 6816 }

i have source like
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100

i want target like

target1
deptno,sal
1,2000
3,4000
4,5000

target2
2,3000
1,2300
5,1100


with out using transformerstage


Answer

1)First go to Seq File-->Columns-->Add RowNum column and
2)then go to Properties-->select Options-->select Row Number Column=RowNum (Drop down list select RowNum column)
we will get the sequence Numbers.

first do the link sort for Sal in transformer stage.

and in Transformer stage go to
Constraint: Mod(dslink1.RowNum,2)=0 ---o/p1

and then select otherwise check box or write Mod(dslink1.RowNum,2)=1 --->0/p2

Is This Answer Correct ?    0 Yes 1 No

Question { Patni, 10993 }

col1
123
abc
234
def
jkl
768
opq
567
789

but i want two targetss target1 contains only numeric values
and target2 contains only alphabet values like

trg1
123
234
768
567
789

trg2
abc
def
jkl
opq


Answer

hi shiva and srinu, its not work properly, would u plz
explain how to write the condition.

Is This Answer Correct ?    0 Yes 0 No

Question { Cap Gemini, 7168 }

i have one table with one column in this column i have three
rows like 1,1,2 then that rows populate to target as first
tow rows as one row and remaing row as one row how it posible?

COLUMN_NAME
SHIVA
RAMU
MADHU

THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND
MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME


Answer

Question is not clear.

U want 1,1 records goes to one target and duplicate records goes to another target, is it right? can u plz conform this and just let me know?

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 8696 }

one file contains
col1
100
200
300
400
500
100
300
600
300
from this i want to retrive the only duplicate like this
tr1
100
100
300
300
300 how it's possible in datastage?can any one plz explain
clearley..........?


Answer

Job Design:

|----->Agg--->Filter1-->|
| |
| |
file-->cp-------------------->Join---->Filter2---->target

Agg: use aggregator and select Agg_type=count rows and then give the Count O/P column=Count (User defined).

Filter1: give the condition Count<>1

Join: select left outer join

Filter2: give the condition Count<>0

u will get the right output....what ever the duplicate records.

and if u want unique records, give the condition Count=0

Is This Answer Correct ?    0 Yes 0 No

Question { 5235 }

in one scenario source flat file like
Fileld1
00122001550056200568
00256002360014500896
00123004560078900258
00147004560025800256
divide each 5 numbers as one column i.e
here i need
field1 field2 field3 field4
00122 00155 00562 00568
00256 00236 00145 00896
00123 00456 00789 00258
00147 00456 00258 00256
plz help me....


Answer

Take 4 field names(field1 field2 field3 field4) in output stage.

use Transformer stage: In Derivation use the below substring

Field1: SourceColumn[1,5]
Field2: SourceColumn[6,10]
Field3: SourceColumn[11,15]
Field4: SourceColumn[16,20] use this one u will get correct o/p.

Is This Answer Correct ?    3 Yes 0 No

Question { Wipro, 6492 }

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec-
2007 or 20-dec-07 in parallel


Answer

use column datatype as varchar

DateToString(StringToDate(DSLink3.DateColumn,'%dd-%mm-%2000yy'),'%mmm-%dd-%yyyy')

use above format in derivation for transformer stage, u will get the desired output.

Is This Answer Correct ?    2 Yes 0 No