In detailed-
I have 5 input files that are completely different formats (the number of columns and metadata are different). How can I read all files using a sequential file stage? When I read the data from each file, how can I confirm which data belongs to which file?

Sincere request, Please suggest for the correct answer. I appreciate any help you can provide.

In source we have 10 files with different metadata and different Source files we need to load the files to target with 10 different target but we should do in a single datastage job how can we do this

Input:
almost
banana
very
begins
order
in


Output:
almost IN ORDER
banana NOT IN ORDER
very NOT IN ORDER
begins IN ORDER
order NOT IN ORDER
in IN ORDER

Explain telecom related project in data stage? For example You are handling data usage and roaming related data. How you will get the data? What mediation team will do? What are the terms such as CDR (Call Detail Record), CDF will you use?

How to integrate an Informatica Data Quality mapplet with DataStage?

To further this, it is probably simple, but :

TABLENAME(Column) CLOB(Column)
HEADER(first row) PROVIDER12082015
MISCROWS IN BETWEEN
TRAILER(last row) 00000000669

If I have three columns created in the transformer (HeadName, HeadDate, RecCount), how would I put this in the derivations?
HeadName is supposed to be equal to PROVIDER
HeadDate...

I am getting a file in and I want to be sure that it has specific traits. The first record must say HEADER, the second record must say PROVIDER, the last record must say TRAILER, Record Count must equal TRAILER count (HEADER - TRAILER = Record Count; TRAILER COLUMN has number of Records)

There is a sequencer 1 scheduled at 12:30 that contains 2 jobs. After sequencer 1 finishes sequencer 2 will execute that again contains 2 jobs. Now if one of the jobs on sequencer 1 fails, then sequencer 2 will not execute. Sequencer 1 should exactly start at 12:30 AM every day. Write the jil script for these sequencers.

Solve with steps

employee_id, salary
-----------------------------
10, 1000
20, 2000
30, 3000
40, 5000

output for (previous row salary in the current row) as below

employee_id, salary, pre_row_salary
-----------------------------------
10, 1000, Null
20,...

Hi,

I have installed the datastage 7.5 in XP operating system, also installed visual studio .net 2008 for c++ compiler. But when trying to compile the datastage job which contain the transformer stage, I am unable to compile.
Below warning I am getting:

Warning: the PWD
environment variable is not defined. Remote process start up may be
unsuccessful as...

I can see the names of newly defined variables in the transformer stage property, but I cannot see the definition and the logic under it. Is it normal? Where can I find the definition of the stage variables?

Could any one please explain me how can we use change capture stage for scd1,2,3 types?

Can anybody tell in detail why we use Rate Routing in Repetitive Mfg. instead Normal Standard Routing?

What is the normal size of data warehouse in a project?

What is meant by real-time integration in terms of datastage and how is different from the same in Informatica.Explain batch and real time processing capabilities of both ETL tools with their characteristic differences?

Explain how data dependency is studied using Metadata of Datastage?

Why and where and how is MQ series stage used in datastage?