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.

input- A B C D a b c d output- A a B b C c D d

I have 3 records . need to compare them fields by fields if there is no change oldest records must go to o/p else if there is change eg if record 2 has changed wrt to record 1 need to send both records to o/p . how to do this using scan component

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

(1) Do the requirements of clause 4.2 of API-650 apply to pressure parts only? (2) What are the material requirements of API-650 for non-pressure parts?

Create n output files with 2000 records each if we have 10000 or 20000 records as input

How can we fetch next record data for a particular field in ab initio? i/p id sal 101 500 102 800 103 900 105 200 o/p id sal Next_sal 101 500 800 102 800 900 103 900 200 105 200 NULL

Ahmad Ali Quraishi

• Aug 12th, 2024

Step 1: Do the rollup on {} key out.id :: accumulation (in.id) out.amt :; accumulation(in.amt) Step 2: Do the normalization Length function Out :: length_of(in.amt) N...

Nishad P

• Feb 25th, 2024

use below flow, i/p -> reformat -> rollup -> normalize -> o/p reformat: add one more column with constant value out.id :: 1; out.* ::in.*; rollup : group the data based on column id created i...

Answer Question  Select Best Answer

How to convert ASN.1 BER data to text data?

I wana cahnge my profeesion please suggest me

Hi, I have a data like 1,a,b,c,2,d,e,f,g required output is in two fields: field1,field2 ----------------- 1,a 1,b 1,c 2,d 2,e 2,f

Yash Chaudhari

• Jan 15th, 2025

Use only 2 components IP ---> REFORMAT ----> FBE ----> OP in reformat transform: /*Reformat operation*/ let string("") f_num = "0"; out::reformat(in)= begin if(string_is_numeric(in.str)) f_...

Ravishek

• Feb 3rd, 2024

Hi Aditya , can you provide actual answer of it?

Answer Question  Select Best Answer

A) By setting the object to NullB) By setting the object to NothingC) With Close keywordD) None of the above

bharathi lakshmi

• Oct 4th, 2024

A) By setting the object to Null

lokesh kumar

• Nov 18th, 2016

B. By setting the object to nothing

Answer Question  Select Best Answer

I have header and trailer records to some body records like below emp.dat|12042016 1/A/1000 2/B/2000 3/C/3000 3 Here there is no record indicator. How will you eliminate and separate header and trailer records without using Next In Sequence, Dedup sorted and any Partition components?

Vicky Gupta

• Dec 6th, 2024

Input File-> Filter by Expression -> Output File

select expr = not (string_index(id,|)>0 or string_is_numeric(id))

Somasekhar Ganta

• Aug 8th, 2024

You dont need so many components to achieve this write input dml as one column like below record string(" ") data; end; and Just connect Reformat and give count parameter to 3 for 3 out ports and...

Answer Question  Select Best Answer

What is the goal of the verification process in software development?

Tejal

• Sep 17th, 2024

The goal of verification process is to ensure that system meets all the requirements.

Ritika

• Jan 16th, 2018

Goal is to verify if the actual output matches the desired output.

Answer Question  Select Best Answer

1.Without using stage variable how can we delete the duplicates using Transformer? 2.If we will remove duplicates using Transformer then minimum how many stage variable required for this?

bhargav Konduru

• Nov 21st, 2024

1.goto tfm stage
2.goto stage properties > goto partitions tab > select hash >select all the columns which duplicates>select sort > select unique
3. that will solve your problem

Mokshada

• Jul 10th, 2021

The prerequisite for this is data should be partitioned by a key and sorted.
Later, follow the below steps:
S2 = if input.column = S1 then 0 else 1
S1 = input.column
In constraint : S2=1

And, you will get the expected result.

Answer Question  Select Best Answer

Can any one help.... Source is..... a b c d want target as..... a,b,c,d thanks in advance

Rajendra

• Jul 30th, 2024

Without "Pivot stage"
Source --> Transfer --> Target
In Transfermer Stage (Sequential mode)
1) Stage Variable: sv = sv:,:inputcolumn
2) Constraint: LastRow()
3) Derivation: Trim(sv,,,"L")

kalyanreddy

• Jan 30th, 2024

Using with pivot stage, we can convert the rows into columns ; source --> pivot -->target.

Answer Question  Select Best Answer

Input file has below contents: Ball Run 1 1 2 1 3 1 4 1 5 1 6 1 1 0 2 1 3 1 4 1 5 1 6 1 1 1 2 1 3 1 4 1 5 1 6 0 Required Output : 1 6 2 5 3 5

UNKNOWN User

• Oct 23rd, 2024

Use rollup with key change function
(in1.ball==6 && in2.ball==1)
This will cover if the 6th ball is a extra ball

Shubham Kandpal

• Jun 22nd, 2024

Use key change and rollup , this code is 100% working

Code
let decimal(x01) over=0;
 
out::key_change(in1,in2)=
begin
out::in2.ball%6 ==1;
end;
 
out::rollup(in)=
begin
over=over+1;
out.ball :: over;
out.run :: sum(in.run);
end;

Answer Question  Select Best Answer

gina may

• Oct 25th, 2024

DORA stands for discover, offer, request and acknowledge: a client broadcast a dhcp discovery message on the network seeking to find a dhcp server, the DHCP server respond to the client with an Offe...

Raghu

• May 7th, 2020

DORA process in DHCP stands for following message flows between the client and the server.

Discover
Offer
Request
Acknowledge

Answer Question  Select Best Answer

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

Bhargav konduru

• Nov 21st, 2024

In TFM stage do the below constraints 1). Link--> @inrownum=1 2).link --> lastrow() 3). link --> click the otherwise condition Some more things needs to do with above 1.In TFM properties set pa...

Prashant

• Nov 25th, 2018

If your output file is sequential file then you can you use filter property .

Answer Question  Select Best Answer

What is the meaning of following extns : 1) .usr, 2) .lrs, 3) .lrr ?

vinod

• Sep 10th, 2024

Urs=vugen,lrs=loadrunner scenario, lrr=loadrunner analyser

raju

• Sep 16th, 2022

Lra means load runner analysis

Answer Question  Select Best Answer

What is the order of execution in the transformer?

Ravi

• Dec 20th, 2024

1. Stage variable
2. it will check for any looping condition is there next
3. it will go for Constraints and derivations

amarnath

• Oct 15th, 2012

What is

1.Stage variables
2.Constraints
3.Derivations

Answer Question  Select Best Answer