How to move the Ab initio graph development to Production or QA?

Sai

• Aug 14th, 2018

We have to deploy using the tag creation, from dev environment to other environment.
Syntax :: air tag create tagname -file filename -exact

Aman Sharma

• May 19th, 2018

We can create tag to move the graph from dev to other environment.
Air create tag /Path/

Answer Question  Select Best Answer

Priyanka Sathe

• May 8th, 2018

Teradata is a RDBMS used specially to build data warehousing applications.
The biggest strength of TD is parellelism.
TD distributes its workload evenly across its system and process it in parallel which makes it much faster than other databases.

Martin Alvarez

 Profile Answers by Martin Alvarez Questions by Martin Alvarez

• Mar 19th, 2012

Teradata and Oracle produce relational database management systems. What the previous answers do not provide are important facts about both platforms. Teradata products are a "combo" of hardware + so...

Answer Question  Select Best Answer

I have to find 2 highest salary from each depart, and employee should have tenure more then 5 years. Table has emp id, name, salary, depart, DOJ. Tried but getting only for 1 depart not for all and no idea about the timestamp, how to subtract to see the tenure.. please advise new in hive still studying for future (: Thanks

How to read nth Row from a File using Sequential File Stage in Datastage
Scenario is as follows:
I have only two stages in a job
SeqFileStage1------> SeqFileStage2
I have to read only 6th Row from File 1 and write it in File2.

Biswajit Rath

• Mar 11th, 2018

We can solve the question by using the head as well as the tail command. So let me explain the answer for finding the nth line by using both the head and tail command. head -nthline fileName | tail -...

Krishna

• Sep 19th, 2017

In sequential file, Use the filter command head -6|tail -1

Answer Question  Select Best Answer

I have a file with 1000 rows I need to split this file that each 100 row is split by a header, to make more clear I need to concatenate the header after 100 row

Harsha

• Feb 7th, 2018

Take the input to sequential file ,in that in filter opinion mention head -100 and output connect it to column import where you mention the schema of input and mention the output schema u need ..so it concatenates entire thing into single row/column.

Correct me if im.wrong.

Answer Question  Select Best Answer

How is transaction time typically represented in a dimensional model

nareshcnr

 Profile Answers by nareshcnr Questions by nareshcnr

• Nov 6th, 2017

Types of Dimension tables : There are mainly three types of dimension tables available in case of Slowly Changing Dimensions Type 1: Never maintain historical data. only update the existing data. e...

Johnny

• Aug 31st, 2017

The following are the type of dimensions
Slowly changing
Fast Changing
Inferred
Junk
Conformed
Degenerate, and
Static

Answer Question  Select Best Answer

Shaheryar Dilawer

• Jul 25th, 2017

Dimension table has to be recorded before the creation of fact table.
The fact table mainly consists of business facts and foreign keys that refer to primary.

Shaheryar Dilawer

• Jul 25th, 2017

A dimension table consists mainly of descriptive attributes that are textual fields. A dimension table contains a surrogate key, natural key, and a set of attributes. The fact table mainly consists of business facts and foreign keys that refer to primary.

Answer Question  Select Best Answer

What is the output (number of records)?
Table A with one column values (1,1,2,2,2,3,4,5)
Table B with one column 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 Inner Join B
6. A Left Join B
7. A Right Join B
8. A Full Join B
9. A Outer Join B

shaili

• Mar 2nd, 2017

A union B : 1,2,3,4,5
a intersection b:1,2,3
a union b minus a intersection b :4,5
a minus b : 4,5
a inner join B :1,1,1,1,1,1,2,2,2,2,2,2,3
a left join b :1,1,1,1,1,1,2,2,2,2,2,2,3,4,5
a right join b :1,1,1,1,1,1,2,2,2,2,2,2,3
a full join b :1,1,1,1,1,1,2,2,2,2,2,2,3,4,5

ram

• May 30th, 2016

1. Union:(1,1,2,2,2,3,4,5)
2. Intersection:(1,1,2,2,3)
3. ::(2,4,5)
4. Aminus b:(2,4,5)

Answer Question  Select Best Answer

Where can we see the number of rows fetched for the last execution time?

my Source is like:

Sno Name
1 XXXX
2 YYYY

I want the Target like:

Sno Name Frequency
1 XXXX 1
2 YYYY 2
2 YYYY 2

How can I replicate the "2 YYYY".
I am supposed to make it dynamic for all possible frequencies.

Visal

• Aug 14th, 2016

From what I understood from the scenario given above, you want to duplicate some particular type of record. use Router and write the same condition (say column1=2) for both output group. Remember defa...

Answer Question  Select Best Answer

I want to create a job which takes input file (containing metadata only) and creates dummy records based on the metadata. Is it possible?

How to do peformance tuning in SQl..??? what are the things involved in tuning..??

How union transformation is active?

jignesh

• Jan 2nd, 2015

No doubt union transformation will give you the result as a passive transformation with same number of records,But row number of the records will get changed in output result set.....eg we have table ...

Answer Question  Select Best Answer

Which type of relation between fact and dimension table in star schema and snowflake schema?like one to one or many to many?

naveen

• Dec 16th, 2014

Parent, child relation between fact,dimensions in star schema,snow flake schema

vveeralapati

 Profile Answers by vveeralapati Questions by vveeralapati

• Apr 25th, 2013

For one dimension record, you will see many fact records associated.Many to one or one to many relationship is not to be confused with number of records or columns in a table. that has nothing to do with a relation

Answer Question  Select Best Answer

Harsh

• Dec 2nd, 2014

Alter index rebuild;

Answer Question  Select Best Answer

What is the main difference between Primary Index and Primary key in teradata? and can we have this two on same column?

uday

• Oct 13th, 2014

Primary Index in Teradata is used for loading and extracting the data from Database. (TD will load data Through PI
) and other hand PK is cluster index uniqe identifier. Pk will not allow Null and duplicates but for PI ok

Agnes Melbin R

• Apr 11th, 2013

If i am not wrong , both the titles should be swapped from the above answer as follows , Primary Key --Always Unique --Does not allow NULL values --Optional for a table --Values cant be updated --Doe...

Answer Question  Select Best Answer

How do you handle the changing no of files as source in the mapping/session which loads the data in a Relational table

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 26th, 2014

If all the files are of the same structure, then we can use the INDIRECT File option. In the indirect file name, give all the sourec file names. Informatica will ftech data from all the source files mentioned in the indirect file.

Kaavya

• Jun 3rd, 2014

Using Indirect file load option

Answer Question  Select Best Answer

How to test workflow in informatica? And how to do ETL testing in Unix?

Explain why database design is important?

LiamWhales

 Profile Answers by LiamWhales Questions by LiamWhales

• Mar 24th, 2014

Database design is the key to a successful database. It reduces the amount of redundant data within the database along with correctly sized columns for minimal space usage whilst ensuring longevity. W...

Sheraz Baig

• Nov 25th, 2013

Database Design is the document which shows the flow of data, its functionality and relationship between tables. This document is very important during database development period , and after the comp...

Answer Question  Select Best Answer