Transformation using Accure Momentum

Default Screen
Default Screen
Click on Add New Configuration
Click on Add New Configuration
Click on Query Editor to launch Query Dashboard
Click on Query Editor to launch Query Dashboard
This is how query dashboard looks like
This is how query dashboard looks like
Left hand side column shows the list of table names
Left hand side column shows the list of table names
If you click on left hand side table name, it will show you the schema on right hand side.
If you click on left hand side table name, it will show you the schema on right hand side.
You can type in your query at the bottom of the table
You can type in your query at the bottom of the table
Once you click on Test, sample output will be shown.
Once you click on Test, sample output will be shown.
You can hit import in order to import the query
You can hit import in order to import the query
Imported query looks something like this
Imported query looks something like this
You have to give other configurations shown in this image
You have to give other configurations shown in this image
Once you save the configuration, it will look like this
Once you save the configuration, it will look like this
Click on Start to start the transformation
Click on Start to start the transformation
It will show you the in progress bar
It will show you the in progress bar
Once finished, you can click on view in order to view the output
Once finished, you can click on view in order to view the output
Successful Transformation will create 4 directories namely 1. contents 2. headers 3. error 4. processed
Successful Transformation will create 4 directories namely
1. contents
2. headers
3. error
4. processed
headers will contain the header file contents will have the contents file
headers will contain the header file
contents will have the contents file
This is contents file
This is contents file
This is how the contents look like
This is how the contents look like
This is header file
This is header file
This is how the header looks like
This is how the header looks like

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s