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...


i/p o/p1 o/p2
1 1 4
1 1 5
1 1 6
2 2
2 2
2 2
3
3
4
5
6
how to populates i/p rows into o/p1&o/p2 using datastage
stages?and also the same scenario using sql?

Answers were Sorted based on User's Feedback



i/p o/p1 o/p2 1 1 4 1 ..

Answer / radhakant kumar

1)by sql say the column name is Id then
a)(for duplicate)
select a.id
from table_name a
left outer join(select id,count(*)as no1
from table_name
group by id
)b
on b.id=a.id
where b.no1>1
order by a.id
it will display 1 1 1 2 2 3 3
b)change the condition where b.no1=1 then it will display
the remainings without duplicates..
2) By DataStage
Step By Step....
a)after source file take Copy stage and draw two
output links
b)one will go to Aggregate stage and take count of
rows by group by Field(id)
it will display like.
ID Count(no)
1 3
2 3
3 2
4 1
5 1
6 1
c)and then use lookup stage main stream will be second link
of copy and reference will be output of Aggregate stage
d)look up key will be ID and fetch count(no) to target
it will display
ID Count(no)
1 3
1 3
1 3
2 3
2 3
2 3
3 2
3 2
4 1
5 1
e)and after lookup stage take transformer or filter stage
by taking two output links and put condition
a)for duplicates count(no)>1
b)for non duplicates count(no)=1

Finally u will get your desired output..
6

Is This Answer Correct ?    13 Yes 1 No

i/p o/p1 o/p2 1 1 4 1 ..

Answer / kalpana_241871

SQL>

SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) > 1 ;

O/P 1 :
1
1
1
2
2
2
3
3
SQL>

SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) = 1 ;

O/P 2 :
4
5
6

Is This Answer Correct ?    11 Yes 2 No

i/p o/p1 o/p2 1 1 4 1 ..

Answer / subhash

SQL> small correct in Query provided by Kalpana.

SELECT COL1 FROM TAB1 WHERE COL1 IN
(SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) > 1) ;

O/P 1 :
1
1
1
2
2
2
3
3
SQL>

SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) = 1 ;

O/P 2 :
4
5
6

Is This Answer Correct ?    5 Yes 0 No

i/p o/p1 o/p2 1 1 4 1 ..

Answer / kavitha

sequentialfile-----copy-----head and tail(in that we have options like no of rows=6 for head and n..o..r=4 for tail)then connect two data sets to that head and tail u will get

Is This Answer Correct ?    1 Yes 0 No

i/p o/p1 o/p2 1 1 4 1 ..

Answer / rvanaja.etldeveloper@gmail.com

just read the data in sequential file
and take aggregator
group=cid
aggregation type=count rows
count output column=countno
then take filter from filter you drag 2 links for two outputs
in filter write conditions like bellow and give link order
where clause=countno>1
and
where clause=countno=1
map in output links
seqfile-->aggregator-->filter-->2 torgets

Is This Answer Correct ?    0 Yes 0 No

i/p o/p1 o/p2 1 1 4 1 ..

Answer / kalpana_241871

hgfh

Is This Answer Correct ?    0 Yes 1 No

i/p o/p1 o/p2 1 1 4 1 ..

Answer / vijaya

Hi

first sort the input date then use the transformer stage by
using stage variables you can use the logic like check the
first record then check the second record if both are equal
send the output to o/p1 or else send to o/p2....

I hope i made u understand the logic

Is This Answer Correct ?    2 Yes 11 No

i/p o/p1 o/p2 1 1 4 1 ..

Answer / srinivas

first sort the data,
then
take two stage variable
if (sv1=sv2) then ds.link1 else ds.link2

Is This Answer Correct ?    1 Yes 13 No

Post New Answer

More Data Stage Interview Questions

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,


what is a message handler

3 Answers   IBM,


what is use of SDR function?

0 Answers   CGI,


How do you design PX Routines ?

1 Answers  


How many areas for files does datastage have?

0 Answers  


what is the diff between sequential file and fileset stages?

3 Answers  


what is a force compile

2 Answers   Cap Gemini, IBM,


Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,


can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,


how to find out number of records imported into source file?

1 Answers  


how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,


How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?

1 Answers   IBM,


Categories