i/p col1||val1||col1||val2||col3||val3
o/p col1 col2 col3
val1 val2 val3
how to achieve this in AB initio

Sneha

• Jun 2nd, 2023

REFORMAT(input column :F1) let int C_FLAG = 0 out :: reformat(in) begin let int count = next_in_sequence(); if count%2 != 0; C_FLAG = string_substring(in.F1,4,1); end; out.COL1 :: if((coun...

Answer Question  Select Best Answer

Rajesh

• Aug 22nd, 2022

ODS is mainly used to integrate the data of different Sources having same functionality of the data into one integrated model. This model is mostly denormalized and will not be useful for reporting. E...

Ankush

• May 18th, 2017

You mentioned ODS comes after staging area is not true i guess. Flow is like ODS->staging->DWH as per my knowledge. Kindly correct me if wrong.

Answer Question  Select Best Answer

Explain about Informatica Power Exchange
What are the important points in Informatica Power Exchange

Shubham R Lashkar

• Sep 22nd, 2022

Informatica PowerExchange is a family of products that enables an IT organization to retrieve all sources of enterprise data without having to develop custom data-access programs. By accessing mission...

Answer Question  Select Best Answer

Can any one let me know where can i find the list of ETL & reporting tolls available in the market. thanks in advance

Prakirn

• Dec 19th, 2020

From performance perspective - Ab Initio
From license cost and market cap perspective - Informatica

shobha

• Mar 20th, 2019

ETL tools are: Informatic power center, Abinition, Data stage, SSIS, ODI

Answer Question  Select Best Answer

What is the other way to mapping the columns without using MINUS

BASAVARAJ Hunshal

• Oct 17th, 2020

Intersect

Or

Full outer join with not null on both tables

pavan

• Oct 26th, 2018

Left join

Answer Question  Select Best Answer

What will be the output (Number of records) for below operators.
Table A has one column with values(1,1,2,2,2,3,4,5)
Table B has one column with values (1,1,1,2,2,3)
1. A Union B
2. A Intersection B
3. (A Union B) minus (A Intersection B)
4. A minus B
5. A Left Join B
6. A Right join B
7. A Inner...

Chinmaya

• Aug 8th, 2019

1.12345
2.123
3.45
4.45
5.ID ID_1

1 1
1 1
1 1
1 1
1 1
1 1
2 2
2 2
2 2
2 2
2 2
2 2
3 3
5
4

6.ID ID_1

2 2
2 2
2 2
2 2
3 3
1 1
1 1
1 1
1 1
1 1
1 1
2 2
2 2

7.inner join
ID ID_1

1 1
1 1
1 1
1 1
1 1
1 1
2 2
2 2
2 2
2 2
2 2
2 2
3 3

Prince Jain

• Apr 8th, 2016

1.12345
2.123
3.45
4.45

Answer Question  Select Best Answer

Raja

• Jun 12th, 2019

if you have Unix, please use this to command on source and target. (checksum bytecount filename). in the file name pls provide your source file name and once the target is also loded, please provide ...

Ayaskanta Ratha

 Profile Answers by Ayaskanta Ratha Questions by Ayaskanta Ratha

• Nov 17th, 2015

You can union both the minus and then look for the result

Answer Question  Select Best Answer

I got the following mapping table and asked me to validate source to target the ETL mapping using Single SQL query. How can we validate source to target the ETL mapping using Single SQL query? I need help to write a query.

Source to Target Mapping Document
Target Table Target Column Source Table Source Column Transformation rule ( ....)
TRG_LOG LOG_KEY ...

swpna

• Jun 17th, 2019

By using minus query (column mapping between source and target

Deepti

• Jan 5th, 2017

Write separate queries as shown below and join by union. Here, it is assumed that LOG_KEY is the key to join both the tables. This way we can know what is the validation that failed and the for which ...

Answer Question  Select Best Answer

How to generate a negative sequence by using sequence generator?

M Farhan

• Dec 29th, 2018

String_concat(-,next_insequence());

Answer Question  Select Best Answer

sravanthi K

• Aug 7th, 2018

Hi Anand ,
I am exactly looking for this info. could you please elaborate on this design implementation in datastage in all the three methods of delta load you mentiond.

Thansks,
Savanthi

Anand Yadav

• Sep 2nd, 2016

There are three way to do increment load in ETL as per my knowledge:
1: Delta loading using parameter file.
2: Delta loading using control table.
3: Delta loading using max variable where max variable is last updated date.

Answer Question  Select Best Answer

I have a ebcdic file, I wanted to select only first 2 columns values in the output in the m_dump command
Output of m_dump values are like below:
[record
id "100"
type_code "20"
frstname "abcd"
lastname "efgh"
new_line "
"]
any help is greatly appreciated

Ashiq Aashu

• Jun 4th, 2018

You can use m_dum < adc.dml > < source file name > -select < expression > hope it will work if you have write a mail.

salma

• Mar 5th, 2018

M_dump -start 1 -end 2 |egrep Record|id|type_code

Answer Question  Select Best Answer

This is my single column table
====================

===
|10|
===
|20|
===
|30|
===
|40|
===
and I want to print out put like this

O/p:
10
===
30
===
50
===
70
How can i get this ?

Rajath

• Dec 15th, 2017

Use CSUM command

Akash

• Jun 24th, 2017

Use router {mod(IP,2)=1}

Answer Question  Select Best Answer

What are the validations you perform after data loads for source to target?

Suresh Reddy

• Sep 29th, 2017

Once the data is loaded in the target tables, we have to do below validations:
1. Counts between source and Target
2. Duplicates check
3. Null Values check
4. Mandatory Values check
5. Data compare (source minus Target and Target minus source)

ashokkumar

• Jul 5th, 2017

Such this type of testing is carried out to validate the data whether source data is transformed to expected target or not and also check the values.

Answer Question  Select Best Answer

I just want to know more about landing area in Datawarehouse
Why landing area required in DWH ?
Diff between landing area and staging area in DWH ?

Suresh Reddy

• Sep 29th, 2017

Landing Area or Landing zone:
This area is used to bring data from multiple source to single zone (say like ODS).
Staging area:
In this area, logics are applied on the data by creating views.

Jasmeet Sahni

• Jan 30th, 2017

Landing area - is the area where we kept the source files from where the ETL tool will be going to extract the data.

Staging area is the initial stage of the database where we just load the load into table without applying any transformation or business rules.

Answer Question  Select Best Answer

How you will find the missing record in the target without using Minus?

VIVEK DIXIT

• Sep 27th, 2017

Count the rows and pass the port in the target

Answer Question  Select Best Answer

What are Initial Load validations and Incremental load validations ?

Bedanta Hazarika

• Sep 23rd, 2017

Initial or Fresh load refers to the state where we truncate or delete all the records from target table and do a fresh load of Data from source. Whereas in incremental load we update the old record...

ashokkumar

• Jul 5th, 2017

Initial load means when ever the target tables are empty that time we are going to load the data from starting year up to this day data loading into data warehouse or data mart is called initial load....

Answer Question  Select Best Answer

How to find number of duplicate records?

Swathi

• Sep 26th, 2017

We can find the duplicates using SQL Query.

Code
SELECT count(Field_NAME) FROM Table_name

Harsha

• Jun 10th, 2016

Code
SELECT count(*),TABLE.* FROM TABLE GROUP BY ALL COLUMNS HAVING Count(*)>1

Answer Question  Select Best Answer

What are the validations you perform from landing area to staging area?

snehal

• Aug 1st, 2017

We check data types, duplication, file types

Answer Question  Select Best Answer

In ETL testing if the src is flat file, then how will you verify the data count validation?

Divya Jain

• May 16th, 2017

Say file Name: abc.txt and delimited with a comma(,)

answer:
hear -1 abc.txt | awk -F "," {print $NF}

Shivnath Rojatkar

• May 12th, 2017

Using wc command in UNIX, you can check the count of records.

Answer Question  Select Best Answer

IF we have a records like below with 2 way mfs using a partition by key, what will be the output.
Key here is Index(Column name)

Index
1
2
3
4
5
5
4
3
2
1

Udit

• Mar 5th, 2017

It must come like:
No., Partition_Value
1,2
2,2
3,2
4,2
5,2

Answer Question  Select Best Answer