how to fetch the last row from a particular column.. Input file may be sequential file...

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

There are multiple ways to do this, given that input is a sequential file. Two of them are

1. Use "Filter" option available in Seq file stage. Specify a unix command like: tail -1 (recommended)

2. Use a tail stage next to Seq filestage and then specify.

Akil

• Apr 1st, 2013

There are 2 ways to fetch the last row of any file if the number of records in the file is not known before run time:

1) Use the tail stage and run the tail stage in sequential mode
2) Use the lastrow() function in the transformer stage

Answer Question  Select Best Answer

What is the uses of the copy stage with out copies input link to output link datasetsand it can have any purposes pls send me with example

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

Use Copy stage for simple operations like :

to multicast the same input data among multiple output links.
placeholder between stages to avoid buffer issues
renaming Columns
dropping Columns
implicit (default) type Conversions

Akila

• Apr 1st, 2013

Besides used for making copies of the input, copy stage is also helpful for achieving 1) dropping columns between stages 2) to change column names 3) if the scenario is to end the job flow directly f...

Answer Question  Select Best Answer

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

In a typical data warehouse environment, we normally have a requirement to keep history. So, we would end up having multiple rows for a given Primary key. So, we define a new column that doesn't have ...

djkool4u

 Profile Answers by djkool4u Questions by djkool4u

• Jul 11th, 2013

Is Slowly Changing Dimension (SCD) Implementation we use Surrogate key as the primary key is being duplicated for the sake of keeping history data for the records with the same pk.

Answer Question  Select Best Answer

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

It depends on the job design and requrement. When you specify SAME partitioning, datastage uses the partioing method defined in the previous stage and will not perform any partitioning in the current...

Muralidhar

• May 30th, 2013

Same partition.
The reason is it keeps the previous partition and send to output as it is.

Answer Question  Select Best Answer

How do we know the no of processors in a job? Is there any specific calculation for this.

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

There will not be any processors in the job. Your question could be - find the number of nodes/processors on which the job is running. So the answer to this - go to Director and open the log for the ...

Kumaresh

• Jul 19th, 2013

Run the job. Go to director log. Check for the apt config data displayed over there. That will show the number of processors/nodes.

Answer Question  Select Best Answer

Hi,
Job1 is running for 10 minutes for the first time and the same job1 is running for 15 minutes for the second time ,the load being the same for both.Could someone explain..

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

One reason could be that - for the first time the job is just loading/inserting data into target. When you run the same job again, it would take more time as it tries to update from second time. Upda...

Raju Nath

• Jun 27th, 2013

Hi you can use the delete and then load command during loading then it will be the same time. First time when you are loading that time the dataset/table is empty that is why its taking less time bu...

Answer Question  Select Best Answer

Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling.

BHANU

• Jul 9th, 2013

Dimensional modeling is a technique for conceptualizing and visualizing the data there are two types of dimensional modeling

1.Snowflake schema
2.Star schema

cyberdiptikanta

 Profile Answers by cyberdiptikanta Questions by cyberdiptikanta

• Jun 26th, 2010

Dimensional Modelling:It is a designing methodlogy for designing datawarehouse with dimensions& facts.It is of three types 1) Conceptual Modelling 2) Logical Modelling 3) Physical Modelling1) Conc...

Answer Question  Select Best Answer

ss

• Mar 28th, 2013

JJ, you are wrong.

Apt_ Dump_Score
By using this only we can find.

jj

• Nov 26th, 2012

1 conductor process
3 Section leader process
3 player process ( modify and filter are combined)
1 source sequential file
1 target sequential file
Total : 9

Answer Question  Select Best Answer

Please answer this question

santosh varma

• Mar 21st, 2013

Your database size is the sum of all datafiles,tempfiles,redologs. so check the sum from dba_data_files,dba_temp_files and v$logfile

Harikrishna Chidrala

• Mar 15th, 2013

It Depends about the size,Example My Development Database size is 6TB and UAT Server is 12 TB and Production is ~25TB.

Answer Question  Select Best Answer

ysubba

• Mar 21st, 2013

Nothing but server name

Answer Question  Select Best Answer

In datastage 8.1 What is the limit of the file size? Is there limit from # of rows and # of field perspective for file extract to be fed in profile stage

varun khare

 Profile Answers by varun khare Questions by varun khare

• Mar 8th, 2013

In 8.0/8.1 it uses parser which requires the entire XML document to be loaded into memory, so that youre limited by the amount of available memory. In 8.5 it uses a really clever streaming app

Answer Question  Select Best Answer

How to see the data in the Dataset in UNIX. What command we have to use to see the data in Dataset in UNIX?

karn khera

• Feb 23rd, 2013

The command which must be used is orchadmin dump datasetname(without quotes). But before that run this command "cd `cat/.dshome`dsenv" without quotes. The reason is: cd `cat/.dshome`-> This will cha...

Saravanan Mani

• Jun 20th, 2012

Orchadmin rm datasetname

Answer Question  Select Best Answer

Hi all, pls let me know the purpose of using User defined environment variables and parameters sets

MallikarjunaG

• Jan 7th, 2013

An user defined environment variable is a place holder to store a value that can used in the entire project. Parameter set is new time saving feature added in DataStage 8x. Parameter set is set of jo...

Answer Question  Select Best Answer

If are given a list of .txt files and asked to read only the first 3 files using seq file stage. How will you do it?

matan

• Nov 16th, 2012

In sequential file we can take a single file by using the file as Specified file.

But we can take the more than one file use File Pattern with different file names.

Metadata must be same.

narra satish

 Profile Answers by narra satish Questions by narra satish

• Mar 25th, 2011

HI, In sequential file we can take a single file byusing the file as Specifyed file.But we can take the more than one file use File Pattern with different file names.Metadata must be same.

Answer Question  Select Best Answer

If you have Numerical+Characters data in the source, how will you load only Character data to the target? Which functions will you use in Transformer stage?

raj

• Nov 8th, 2012

Example : raje123ndh456ar

Code
convert(0123456789,,raje123ndh456ar) = rajendhar 

now it is converted to character string and we can load only character.

Vinay Sharma

• Oct 4th, 2012

Use alpha function.
Exp-->alpha(123vinay567)
Ans-->vinay

i thing this is your requeriment..

Answer Question  Select Best Answer

Source has sequential file stage in 10 records and move to transformer stage it has one output link 2 records and reject link has 5 records ? But i want remaining 3 records how to capture

Shirisha

• Oct 10th, 2012

You can choose O.W option in constraints, so remaining records you will get.

anil_k_nayaka

 Profile Answers by anil_k_nayaka Questions by anil_k_nayaka

• Jan 25th, 2012

In the transformer Stage Constraints we can define the constraints where this records can get to which link so that the missing records can get catched.

Answer Question  Select Best Answer

Scenario- if suppose we have 3 jobs in sequencer, while running if job1 is failed then we have to run job2 and job 3 ,how we can run? plz ans this thanks in advance

Rekha Ramakrishnan

 Profile Answers by Rekha Ramakrishnan Questions by Rekha Ramakrishnan

• Aug 23rd, 2012

In the first sequence trigger condition there would be option like condition, unconditional, failed etc. You can select Unconditional so that even if first sequence fails or succeed it automatically redirect to next sequence.

Gopi N

• Jul 11th, 2012

If the scenario we have like 1st is abort and then trigger 2nd and 3rd do the below, give the trigger condition like, 1> If job aborted give the link trigger condition which is going to 2nd and 3rd j...

Answer Question  Select Best Answer

If you have a huge volume of data to be referenced, which stage will you use? Join or Lookup stage? Why

Gopi N

• Jul 11th, 2012

If we have a Huge data at reference defiantly we should go to Join stage because Look up takes much time to process hence we will use entire partition but in Join stage we will give the sorted data and it will simplify better than Look-up

arjunreddy

• Aug 24th, 2011

Look up stage

Answer Question  Select Best Answer

Gopi N

• Jul 11th, 2012

We can filter the data in hash file based on the key column, If we have a key duplicate we reject in to files as well by writing a SQL statement

Answer Question  Select Best Answer

joel

• Jun 20th, 2012

The above answer is wrong. Please follow the steps below to load the excel in dataastage :- first open excel sheet and open->saveas-> then save the file as .csv extension while importing u have to s...

srinu5077

 Profile Answers by srinu5077 Questions by srinu5077

• Jan 4th, 2012

I did same as step1, but when i import the metadata it asking username and password, when press ok button it shows NO MATCHES FOUND, pls help me

Thank you
Regards
Srinivas

Answer Question  Select Best Answer